Rank Question

[kattlees]

I have this rank column:

Rank =
VAR Symbol = V_ACCT[visit_mr_num]
RETURN
RANKX (
FILTER ( ALL ( V_ACCT ), V_ACCT[visit_mr_num] = Symbol ) ,
V_ACCT[Admit Date],
,
ASC
)

See my screenshot below. Why would it not go in order of 1,2,3 in the blue box but does for the other one? There are only 3 records with the mr_num of 001029478.

[v-yulgu-msft · Accepted solution]

Hi @kattlees,

I tested the above Rank formula on my side, it returned correct rank values as you can see in below image. It also display correctly when I add fields to table visual.

Please provide more details about your source data.

Regards,

Yuliana Gu

[precedence]

It's ordering by the left most Items in the table.  So after Visit_mr_num it's then sorting by Guest ID rather than rank. 

Can you try moving Rank to be the first column in the table?