Rankx not working!

[Anonymous]

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!

[mbamber · Accepted solution]

CALCULATE needed for context transition:

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

[Anonymous]

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?

[mbamber]

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.