RANKX Measure issue

[OjasBI]

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 !!!!

[v-jiascu-msft · Accepted solution]

@OjasBI

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

[OjasBI]

Thanks Dale !!!
That helped.