Dynamic Rank Measure for Table visualization

[BrianRiggin]

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!

[DataInsights · Accepted solution]

@BrianRiggin,

RANK is a better choice than RANKX for most scenarios. Try this measure:

Rank = 
RANK ( ALLSELECTED ( MyTable ), ORDERBY ( MyTable[RankingNumber], ASC ) )

[BrianRiggin]

That worked!  Thanks!