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

Hi Guys, 

 

I am having a very similar problem but the suggestions above do not seem to have resolved my issue. I too am working with decimal numbers. I cannot change the data type for this dataset as the decimal numbers is integral to the dataset and the workings out. 

 

Here's the issue that i'm having.... (picture below)

The table with rankings on the left is correct - the ranking issue is the one that has a red ring around it (the table is being filtered by a subject. 

 

The card on the right (circled) should say 14, but it is saying 15. It is reading the same rank formula as the table, it is also being filtered by a subject, but it has an additional filter on it for Institution. 

 

This only happens for a couple of subjects - the vast majority of the other subjects have the correct ranking in the card.

 

Any ideas?? Would be most grateful if anyone has any! 

 

Thanks!