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 using "ALL" for table argument and many other solutions and nothing seems to be working!

  • mbamber's avatar
    mbamber
    3 years ago
    CALCULATE needed for context transition:

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

3 Replies

  • 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.