Rank a calculated measure

[Capt.Ragnar]

I think this is formally referred to a dynamic rank so something similar in Tableau.

If I have a calculated measure, how might I create a rank of the results. Not sure if RankX or Rank.eq can facilitate this.

 

[easy2understandexcel]

You want the smallest or largest numbers in order?
You can use =LARGE($A$1:$A$99,1) to get the largest... =LARGE($A$1:$A$99,2) to get the 2nd largest...
So you would set the Nth number (1, 2, 3) to another column that contained the values (1, 2, 3, 4, ...) and the formula next to it... and get the top values.

Not sure if thats exactly what youre looking for, let me know if not...

 

[FDibbins]

Ranking a list of calculated answers is no different to ranking a list of entered values