Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to 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
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
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?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
105 | |
93 | |
75 | |
62 | |
50 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |