Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to 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
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
I actually figured it out using another way but thank you for the resource.
User | Count |
---|---|
101 | |
90 | |
80 | |
71 | |
69 |
User | Count |
---|---|
114 | |
97 | |
97 | |
73 | |
72 |