Rankx - Getting incorrect ranks

[gauravdoshi06]

Hi,

Why am i not getting correct ranks? Anything wrong with the formula?

[amitchandak · Accepted solution]

@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