topic Rankx not working! in DAX Commands and Tips

Rankx not working!

Anonymous — Thu, 29 Sep 2022 11:26:48 GMT

Hello everyone,

I have a table with 2 columns (product code, sold qty). I want to create a rank measure using Rankx that ranks the products as below:

I tried everything outhere such as using "ALL" for table argument and many other solutions and nothing seems to be working!

Re: Rankx not working!

mbamber — Thu, 29 Sep 2022 12:10:50 GMT

CALCULATE needed for context transition:

RANKX(ALL('Table'[Product Code]), CALCULATE(SUM('Table'[Sold Qty])))

Re: Rankx not working!

Anonymous — Thu, 29 Sep 2022 12:43:51 GMT

Thanks a lot man! it actually worked

I'm Just curious what difference does it make to use :

RANKX(ALL('Table'[Product Code]), CALCULATE(SUM('Table'[Sold Qty])))

instead of

RANKX(ALL('Table'[Product Code]), SUM('Table'[Sold Qty]))

Why did the first work and the second failed?

Re: Rankx not working!

mbamber — Thu, 29 Sep 2022 12:47:24 GMT

This is called "context transition".
If instead of CALCULATE(SUM('Table'[Sold Qty])) you would use a reference to a predefined measure [Total Sold], that would also work.