Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Rankx not working!

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 usi...
  • mbamber's avatar
    mbamber
    3 years ago
    CALCULATE needed for context transition:

    RANKX    (ALL('Table'[Product Code]), CALCULATE(SUM('Table'[Sold Qty])))
mbamber's avatar
mbamber
Frequent Visitor
3 years ago
CALCULATE needed for context transition:

RANKX(ALL('Table'[Product Code]), CALCULATE(SUM('Table'[Sold Qty])))
  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    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's avatar
      mbamber
      Frequent Visitor
      3 years ago

      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.