Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I've read a lot of postings on this, but I just can't seem to get it to work. I have a base table that looks like this:
Thingy (Unique) | RankingNumber |
a | 12345646 |
b | 9988544 |
c | 54654 |
d | 654654654 |
e | 654654654 |
f | 89191813 |
I want to put this into a visual to and add a measure showing the rank like this:
Thingy (Unique) | RankingNumber | Rank |
a | 12345646 | 3 |
b | 9988544 | 2 |
c | 54654 | 1 |
d | 654654654 | 5 |
e | 654654654 | 6 |
f | 89191813 | 4 |
So when I filter it by A and E for instance, I get:
Thingy (Unique) | RankingNumber | Rank |
a | 12345646 | 1 |
e | 654654654 | 2 |
I've tried this, but I get an error saying it can't find a single value for RankingNumber
RANKX(ALLSELECTED(MyTable),MyTable[RankingNumber],,DESC)
And I've tried these, but everything has the same value for every row corresponding to the count of total rows in MyTable
RANKX(ALLSELECTED(MyTable),MyTable[RankingNumber],MAX(MyTable[RankingNumber]),DESC)
RANKX(ALLSELECTED(MyTable),MyTable[RankingNumber],CALCULATE(SUM(MyTable[RankingNumber])),DESC)
Any help would be greatly appreciated!
Solved! Go to Solution.
RANK is a better choice than RANKX for most scenarios. Try this measure:
Rank =
RANK ( ALLSELECTED ( MyTable ), ORDERBY ( MyTable[RankingNumber], ASC ) )
Proud to be a Super User!
RANK is a better choice than RANKX for most scenarios. Try this measure:
Rank =
RANK ( ALLSELECTED ( MyTable ), ORDERBY ( MyTable[RankingNumber], ASC ) )
Proud to be a Super User!
That worked! Thanks!
User | Count |
---|---|
102 | |
92 | |
85 | |
78 | |
71 |
User | Count |
---|---|
113 | |
104 | |
101 | |
73 | |
65 |