Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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.
User | Count |
---|---|
128 | |
108 | |
100 | |
64 | |
62 |
User | Count |
---|---|
136 | |
113 | |
102 | |
71 | |
60 |