RANKX not working as expected

[Anonymous]

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

total sum = sum('FoodMart-Transaction-(1997-1998)'[quantity])

RANKX = Rankx(all('Calendar-Lookup'),[total sum])

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??

RANKX = Rankx(all('Calendar-Lookup'[YEAR]),[total sum])

Regards,

Husna

[Anonymous]

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

[amitchandak]

@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