Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

RankX

RankX measure in card visual is showing a different number to the rank displayed in a table visual,    Is there any solution for this?  
DAX
Fowmy's avatar
Fowmy
Super User
2 years ago

Anonymous 

Yes that's correct, it all depends on the context on which the calculation happens. Please provide some data and the expected results.

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    I am using the RANKX(ALL(Category[Category Names]), [Premium]) formula in the table and card visual. When I filter for a specific category it gives a different result in the table and card visual.

     

    Do I need to use a different measure for the card visual?

    • Fowmy's avatar
      Fowmy
      Super User
      2 years ago

      Anonymous 

      You can use the same measure for both as follows. Change DESC  to ASC if needed.

      Rank Category = 

RANK(
    DENSE,
    ALL(Category[Category Names], 
    ORDERBY( [Premium], DESC ) 
)