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.

kathrynhmoss's avatar
kathrynhmoss
Icon for Helper I rankHelper I
3 years ago

Hi, 

 

It's been a while since i looked at this, but i believe we found a formula that we were happy to use. 

 

Rank = RANKX(ALL(Your dataset[what you want to rank]),Your dataset [measure/metric you want to rank by)
 
Let me know if this works for you?
 
Thanks
 
Kathryn
kathrynhmoss's avatar
kathrynhmoss
Icon for Helper I rankHelper I
3 years ago
There was also something about multiplying by 100,000 but i can't for the life of me remember why we had to do that.