Forum Discussion

JOKA's avatar
JOKA
Icon for Advocate I rankAdvocate I
7 years ago
Solved

RANKX in Card

Hi! I´m having trouble with a Rankx measure when displaying on a card.  I have a rank of sales by user: Rank = RANKX(ALL(TABLE[User]);[Sales];;DESC;Dense) If I use Rank in a table all users have t...
Need Help
  • JOKA's avatar
    JOKA
    6 years ago

    In case there´s someone else with the same problem. There´s something wrong when you try to rank decimals. To solve the problem we had to change the measure in the overall rank to integer.

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi JOKA ,

 

You can create the following two measures to display rank:

 

Normal Rank = 

RANKX(ALLSELECTED(TABLE[User]),CALCULATE(SUM([Sales]),,DESC,Dense)

 

Overall Rank = RANKX(ALL(TABLE[User]),CALCULATE(SUM([Sales]),,DESC,Dense)

 

Then try putting the Normal Rank in a table visual and then Overall Rank Measure in the Card Visualization. Now if you will slice and click on, let's say Rank 3 record in the table, the card will show Rank 3 as well.

 

Hope this helps. 

 

**Please mark this as answer if it solves your problem. Thanks

sivasrao's avatar
sivasrao
Icon for Helper III rankHelper III
3 years ago

Yes, it is working. Great.

Thank you.