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

Hello!

I found this in other forum and it works!

= RANKX(ALL(Products), SUMX(RELATEDTABLE(InternetSales), [SalesAmount]))

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Thank you!