Forum Discussion
bhurru
Helper I
5 years agoNational ,Regional and Territory Ranks
Greeting Folks! My question might have been asked previously in the forum, however I didn't get a solution. I have a measure which ranks by Region(3 distinct region , 18 distinct District and 13...
amitchandak
Super User
5 years agobhurru , Meausre Rank is context sensitive
for the first one
rankx(All(Table[region]),[meausre])
rankx(Allselected(Table[region]),[meausre])
For second table
rankx(filter(Allselected(Table[region]),Table[district] =max(Table[district])),[meausre])
rankx(filter(All(Table[region]),Table[district] =max(Table[district])),[meausre])
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
bhurru
Helper I
5 years agoThanks ..but it didn't worked.
I get 1s across rows