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.
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.
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 |
---|---|
109 | |
99 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
87 | |
64 |