Forum Discussion

OjasBI's avatar
OjasBI
Frequent Visitor
9 years ago
Solved

RANKX Measure issue

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....
Interesting Links
Need Help
Show and Tell
  • v-jiascu-msft's avatar
    v-jiascu-msft
    9 years ago

    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

     

v-jiascu-msft's avatar
v-jiascu-msft
Microsoft Employee
9 years ago

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's avatar
    OjasBI
    Frequent Visitor
    9 years ago

    Thanks Dale !!!
    That helped.