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

amitchandak's avatar
amitchandak
Super User
5 years ago

Erika_S , Measure seems to fine at a high level. Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

What is wrong , what is expected