rankx Returns no #1 and multiple of some other numbers

[Anonymous]

In this screenshot the first column is RANKX based on the second column. Formula: Jan VAR Rank = RANKX(ALLSELECTED('SRO DATA'),[Jan ABS VAR], ,Desc) I can't figure out why there is no number 1 in the rank column and there are multiples of some numbers even though the ABS VAR column is not the same number. For the most part, it seems to be putting them in the correct order but for the Rank 12, they are out of order.

[v-yulgu-msft · Accepted solution]

Hi @Anonymous,

Please try this:

Jan VAR Rank = RANKX(ALL('SRO DATA'),[Jan ABS VAR], ,Desc,Dense)

Regards,

Yuliana Gu

[Phil_Seamark]

Hi @Anonymous

Are you adding this as a calulated column to an existing table, or as a calculated measure?

[Anonymous]

Both the Rank and the Variance columns are measures.