Forum Discussion

Erika_S's avatar
Erika_S
Helper I
5 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
    5 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

Erika_S's avatar
Erika_S
Helper I
5 years ago

I couldnt open pbix - says my version is too old:( so sorry...

amitchandak's avatar
amitchandak
Super User
5 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