Forum Discussion
gauravdoshi06
5 years agoNew Member
Rankx - Getting incorrect ranks
Hi,
Why am i not getting correct ranks? Anything wrong with the formula?
gauravdoshi06 , measure rank is context-sensitive
Try like
Rankx(allselected(Table[Specialty]), calculate(sum(Table[Value])))
For Rank Refer these links
https://radacad.com/how-to-use-rankx-in-dax-part-2-of-3-calculated-measures
1 Reply
- amitchandakSuper User
gauravdoshi06 , measure rank is context-sensitive
Try like
Rankx(allselected(Table[Specialty]), calculate(sum(Table[Value])))
For Rank Refer these links
https://radacad.com/how-to-use-rankx-in-dax-part-2-of-3-calculated-measures