Simple RANKX instructions - how to get rank value on a matrix with slicers?
I want to achieve something seemingly simple, alas I'm failing miserably!
I have a table that contains unpivoted KPI metrics (e.g. awareness, quality, intention, etc)
I have created a report page with the following slicers:
- Date range
I have created a matrix that returns the average value based on the above filter selections, for example:
Brand Average of Score
What I want to achieve, is a table that contains the ranking value instead of the average score, so:
Although this seems extremely easy, I have spent a good hour looking for a solution, but haven't managed to make it work. What confuses me is whether to use ALL, ALLEXCEPT, etc. and how as the Rank measure has to abide by all slicer selections for it to work.