Using RANKX to rank categories based on Report Level FIlters

[Anonymous]

Hello,

I have searched a lot around the web and couldn't really find an answer to this problem I am having. '

I first have a measure that takes an average percentage of Column1 in Table 1. Then I am trying to make another measure that ranks this average percentage measure based on categories in Column 2. I have also used a report level filter to filter out all of the categories I want to use fro the rank measure and other calulation in the report. The thing is when I have a list visual filter in the page and try to select on of the categoreis it gives the rank for all the categories and not just those categories selected in the report filter.

I was wondering if anyone has a solution to this because I have tried all of the ALL functions in various ways with no luck.

Thanks

[Chihiro · Accepted solution]

Can you upload sample data set? Along with image of expected result. Bit hard to help you without it.

If unable to, below link will help, specifically Ranking by Sub Category section.

http://radacad.com/how-to-use-rankx-in-dax-part-2-of-3-calculated-measures

[Anonymous]

I actually figured it out using another way but thank you for the resource.