Forum Discussion

AmudhaKumaran's avatar
AmudhaKumaran
Helper I
4 years ago
Solved

RANKX

Hi Team,   Looking for hep on RANKX function. Any immediate help is appreciated.  I have a fact table with multiple rows for a single ID based on many dimensions. Total score is identified for eac...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi，

    Please refer the following formula.

     

    rank1 = 
var _tab=SUMMARIZE('Table','Table'[total scare])
Return
RANKX(_tab,[total scare],,DESC,Dense)

     

    final = 
var _count1=CALCULATE(DISTINCTCOUNT('Table'[name id]),FILTER('Table','Table'[rank1]<EARLIER('Table'[rank1])))
var _count2=CALCULATE(DISTINCTCOUNT('Table'[rank1]),FILTER('Table','Table'[rank1]<EARLIER('Table'[rank1])))
Return
'Table'[rank1]+_count1-_count2

     

     

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

     

    Best Regards

    Community Support Team _ Polly

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi，

Please refer the following formula.

 

rank1 = 
var _tab=SUMMARIZE('Table','Table'[total scare])
Return
RANKX(_tab,[total scare],,DESC,Dense)

 

final = 
var _count1=CALCULATE(DISTINCTCOUNT('Table'[name id]),FILTER('Table','Table'[rank1]<EARLIER('Table'[rank1])))
var _count2=CALCULATE(DISTINCTCOUNT('Table'[rank1]),FILTER('Table','Table'[rank1]<EARLIER('Table'[rank1])))
Return
'Table'[rank1]+_count1-_count2

 

 

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

 

Best Regards

Community Support Team _ Polly

AmudhaKumaran's avatar
AmudhaKumaran
Helper I
4 years ago

Hi Anonymous 

 

Thank you so much for your response. That really solved my issue. Rank is now working as expected.