I am creating a pivot table for survey results. I would like the measure to be a percentage of responses per answer item per question. Using the following measure Count(AnswerItem)/Count(Total(Question)) it works when I have 1 question selected. I am trying to use the aggr function so each count(total(question)) is independent from the overall count so if I remove the filter it will still calculate the percentage of responses for each answer item. Any help would be greatly appreciated.
Dimensions: Question(row)
AnswerItem(Column)
Measure: Count(AnswerItem)/Count(Total(Question))
