RANKX not working as intended

[Anonymous]

Hi all,

Trying to create a simple ranking based on Gross Profit (Measure) Sadly couldn't get it working. Tried using Gross Pay (Column) pretty much the same result. If i remove the empName from the ALL SELECTED line then it will show some kind of ranking but not in order 1-2-3-4 etc it will show 1-8-24 etc. Any help or guidance would be apprciated, already read through a few posts and watched the video below

https://www.youtube.com/watch?v=Anv3X3EuHZ8

[Ashish_Mathur]

Hi,

The title of the column is Employee Name but you are referring to EmpName in your formula.  Could that be the reason?  Also, ensure that you write this as a measure (not a calculated column formula).

[Anonymous]

Measure = RANKX(ALL(Test),CALCULATE(SUM(Test[GrossPay])))

@Anonymous