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 Measures
however, when i try to give ALL() function with table[column name] its working fine how ?? shouldnt that yeild correct result irrespective of table name or column name??
Regards,
Husna
2 Replies
- amitchandak
Super User
Anonymous , 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 Hi
Could you tell me if your problem has been solved?
If it is, kindly Accept it as the solution. More people will benefit from it.
Or you are still confused about it, please provide me with your original data and relationship between tables.https://www.sqlbi.com/articles/use-of-rankx-in-power-bi-measures/
Best Regards,
Stephen Tao
