RANKX Measure issue

Question

Hi,&nbsp;&nbsp;I was trying to create rank using RANKX function.However I was facing an issue.&nbsp;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.&nbsp;Any help is appreciated.Thanks !!!!&nbsp;

v-jiascu-msft · Accepted Answer

OjasBI&nbsp;Hi,&nbsp;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] ) ) )&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Best Regards!Dale&nbsp;

Forum Discussion

RANKX Measure issue

2 Replies

Related content

RANKX Measure issue

RankX

Averagex issue

RANKX ISSUES

RANKX issue