Forum Discussion

Erika_S's avatar
Erika_S
Icon for Helper I rankHelper 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