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

vanessafvg's avatar
vanessafvg
Icon for Community Champion rankCommunity Champion
6 years ago
ericka can you share some of your data and then say what you are trying to do? Are you ranking agent by total calls. what are you expecting. Why is 1-66 wrong, what rank are you wanting.