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 AmudhaKumaran ,

 

Create a measure to reference the value of total score.

 

total = SELECTEDVALUE('Table'[total scare])

 

Then create a measure to sort.

 

measure = RANKX(ALL('Table'),[total],,DESC,Dense)

 

 

 

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

joglidden2's avatar
joglidden2
Post Patron
4 years ago

This is actually the only example of RANKX() I've ever been able to get working. Why is DAX in PBI such complete witchcraft? Nothing in Microsoft's documentation even hints at this solution. Sheesh.