Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
Solved! Go to Solution.
Hi @Anonymous,
Please try this:
Jan VAR Rank = RANKX(ALL('SRO DATA'),[Jan ABS VAR], ,Desc,Dense)
Regards,
Yuliana Gu
Hi @Anonymous,
Please try this:
Jan VAR Rank = RANKX(ALL('SRO DATA'),[Jan ABS VAR], ,Desc,Dense)
Regards,
Yuliana Gu
Hi @Anonymous
Are you adding this as a calulated column to an existing table, or as a calculated measure?
Both the Rank and the Variance columns are measures.
User | Count |
---|---|
91 | |
77 | |
71 | |
64 | |
58 |
User | Count |
---|---|
106 | |
97 | |
76 | |
63 | |
60 |