Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.
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.
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.