Forum Discussion
Solved
Creating average grouped by multiple grouping variables
Hi all, I would like to create a measure that represents the average of two (or potentially more) categories. My data looks like this User Cat_A Value 1 East 30 1...
Try:
Average of response average per CAT=
CALCULATE(AVERAGE('answers_valid'[value]),
ALLEXCEPT('my_data','my_data'[Cat_A],'my_data'[Cat_B]))Appreciate your Kudos
Connect with me!
Hello amitchandak
Thanks for your idea. This is precisely what I tried with one grouping variable and it works perfectly. However, what if I have two grouping variables (User and Cat_A in my example).
Any ideas?
Thanks,
A.
Try:
Average of response average per CAT=
CALCULATE(AVERAGE('answers_valid'[value]),
ALLEXCEPT('my_data','my_data'[Cat_A],'my_data'[Cat_B]))
Appreciate your Kudos
Connect with me!