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

I'm sorry, i don't have any more ideas. The formula that i provided worked for my data.

 

I did spend several weeks at the time trying to resolve it and tried so many things that i can't actually remember what the thing was that made it work in the end. It was a year ago! 🙂 

 

 

Anonymous's avatar
Anonymous
Not applicable
3 years ago

oh ok thanks anyway for your help! 

 

I will keep trying