Reply
Regular Visitor
Posts: 15
Registered: ‎04-11-2017
Accepted Solution

RANKX Measure issue

[ Edited ]

Hi,

 

Rank.png

 

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

 


Accepted Solutions
Highlighted
Super Contributor
Posts: 2,380
Registered: ‎05-02-2017

Re: RANKX Measure issue

@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] ) ) )

 

RANKX Measure issue.jpg

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Best Regards!

Dale

 

View solution in original post


All Replies
Highlighted
Super Contributor
Posts: 2,380
Registered: ‎05-02-2017

Re: RANKX Measure issue

@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] ) ) )

 

RANKX Measure issue.jpg

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Best Regards!

Dale

 

Regular Visitor
Posts: 15
Registered: ‎04-11-2017

Re: RANKX Measure issue

Thanks Dale !!!
That helped.