I have been piecing this dashboard together and this is the last item I cannot figure out.
I have survey data for a range of questions that include the category, date asked, department of responder, score of responder, etc. The source data is an individual response index. One question is asked per week, so there is no question overlap with date_asked and can reliably be grouped by.
I need a bar chart that breaks out all responses returned based on slicers by the score. The bar needs to be a 0-100% ratio of total responses (54% of responses scored "4"). The legend is by "date asked" so the stacked bars can compare previous times a question was asked.
Where I am running into trouble is using a slicer that filters by department. I need to be able to dynamically count the scores by score and total responses by date_asked so that the sum of all the bars per legend slice is always 100%. This is the closest we got to doing it in DAX:
CALCULATE(CONVERT(COUNT(tinypulse_responses[date_asked]), DOUBLE) / CONVERT(DISTINCTCOUNT(tinypulse_responses[question_text]), DOUBLE))
Please let me know where I can clarify further. Greatly appreciate any help!
(I tried to post images of what I have now but am not allowed to yet.)