Forum Discussion
RANKX not working as expected
Hi All, I have a simple query my RANKX is not working as expected can someone please explain me whats wrong? when i try to use ALL() function with only table name giving wrong result as below My...
amitchandak
Super User
Super UserAnonymous , rank is context-sensitive. In the first case, the rank would be calculated at the lowest level of the calendar each year.
Refer this to get how Rank works
https://radacad.com/how-to-use-rankx-in-dax-part-2-of-3-calculated-measures