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
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 ) 
)