Forum Discussion

Erika_S's avatar
Erika_S
Helper I
6 years ago
Solved

Rankx not working

Hi everyone, Hope maybe you can help? I am trying to build Rankx measure but it keeps coming back with 1 to 66 🙂  This is the dax i tried: Ranking = RANKX(ALLSELECTED('Agent level stats'), CALCUL...
Need Help
  • amitchandak's avatar
    amitchandak
    6 years ago

    Erika_S ,

    formulas

    Calls = SUM('Table'[Number of Calls Handled])
    Rank = rankx(ALLSELECTED('Table'[Agent ID]),[Calls],,DESC,Dense)

     

    what it is showing

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi Erika_S ,

 

Create a measure

 

No. of Calls handled Measure = SUM('Table'[Number of Calls Handled])
 
Ranking Measure = RANKX(ALL('Table'[Agent ID]), [No. of Calls handled Measure],,DESC)
 
 
 
Regards,
Harsh Nathani
Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)
Erika_S's avatar
Erika_S
Helper I
6 years ago

This almost worked! I have added "Dense" as it was showing the bottom few as all on Rank 20. Dense didnt help though.

Ranking = RANKX(all('Agent level stats'[Agent ID]),[No Calls Handled],,DESC,Dense)
 
thank youuuu!!