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.
Hello everyone,
I'm getting some wierd values which I can't understand and they aren't what I was expecting to get.
I have a calculated column based in this formula:
Sales (EUR) = Sales[Amount]/ Sales[RATE EUR-USD]
And my measures are:
Total Revenue = SUM(Sales[Sales (EUR)]) Rank ASC = RANKX(ALL(Sales);[Total Revenue];;ASC) Rank DESC = RANKX(ALL(Sales);[Total Revenue];;DESC)
I can't understand the the ranking values, I was expecting to get sequencial numbers from 1 to 7 and 7 to 1 as I only got 7 different clients at my table data.
I can't figure what I'm doing wrong.
Solved! Go to Solution.
Problem solved, I was using the table to calc the rank and not the firld that iIactualy was expecting to be ranked.
Solved using:
Rank ASC = RANKX(ALLSELECTED(Sales[Client Name]);[Total Revenue];;ASC) Rank DESC = RANKX(ALLSELECTED(Sales[Client Name]);[Total Revenue];;DESC)
But please, if anyone has a better idea please tell.
Problem solved, I was using the table to calc the rank and not the firld that iIactualy was expecting to be ranked.
Solved using:
Rank ASC = RANKX(ALLSELECTED(Sales[Client Name]);[Total Revenue];;ASC) Rank DESC = RANKX(ALLSELECTED(Sales[Client Name]);[Total Revenue];;DESC)
But please, if anyone has a better idea please tell.
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 |
---|---|
114 | |
100 | |
81 | |
70 | |
62 |
User | Count |
---|---|
148 | |
116 | |
104 | |
90 | |
65 |