Forum Discussion
Solved
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
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