Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi,
I was trying to create rank using RANKX function.
However I was facing an issue. Lets consider above scenario.
I have sorted the data by Rank above.
The rank for the 1st row is 4. This is because there are 4 rows for that Region, Cat and Supp.
They have been aggregated and displayed which is fine.
However, the rank displayed is 4. I want to give Rank 1,2,3...
Basically calculate the rank based on the rows in grid and not what is there in db.
Any help is appreciated.
Thanks !!!!
Solved! Go to Solution.
Hi,
It seems that you used RANKX in a calculated column. You can make the visual display from 1. But this couldn’t be your purpose. Maybe you need a measure like this. Please have a try.
MeasureRankx = RANKX ( ALL ( 'Table'[Supp] ), CALCULATE ( SUM (‘Table’[Sp] ) ) )
Best Regards!
Dale
Hi,
It seems that you used RANKX in a calculated column. You can make the visual display from 1. But this couldn’t be your purpose. Maybe you need a measure like this. Please have a try.
MeasureRankx = RANKX ( ALL ( 'Table'[Supp] ), CALCULATE ( SUM (‘Table’[Sp] ) ) )
Best Regards!
Dale
Thanks Dale !!!
That helped.
User | Count |
---|---|
141 | |
113 | |
104 | |
78 | |
64 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |