Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
In my organization we have our stores set up in a hierarchy that goes Region > District > Store. Each level of hierarchy has its own performance scorecard, and each Store/District/Region is ranked based on that score. I currently use this formula to produce a rank at each level:
Solved! Go to Solution.
Use a calculated column rather than a measure. Calculated columns are only refreshed once during data source refresh, and are unaffected by filter changes.
@Anonymous , Create a measure rank with allselected in place of ALL
For Rank Refer these links
https://radacad.com/how-to-use-rankx-in-dax-part-2-of-3-calculated-measures
https://radacad.com/how-to-use-rankx-in-dax-part-1-of-3-calculated-columns
https://radacad.com/how-to-use-rankx-in-dax-part-3-of-3-the-finale
https://community.powerbi.com/t5/Community-Blog/Dynamic-TopN-made-easy-with-What-If-Parameter/ba-p/367415
Use a calculated column rather than a measure. Calculated columns are only refreshed once during data source refresh, and are unaffected by filter changes.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |