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
3 years ago

 

 

On the Card visual I have filtered for a client but I am getting the rank as 9 but on the table it is showing the rank as 8.

 

The formulae used is rankx(all(client),value(gross premium)

 

I have tried using Allselected in the formula but this just gives a rank as 1

 

Would really appreciate any solutions,

 

Thanks, 

 

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. 
  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi, 

     

    thanks for this, I tried this 

    Rank = RANKX(ALL(Your dataset[what you want to rank]),Your dataset [measure/metric you want to rank by) but am still getting an error where the rank in the card is giving me a rank higher than it should be 
     
    thanks,