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.
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.
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 |
---|---|
110 | |
95 | |
76 | |
65 | |
51 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |