Forum Discussion

Radhika2605's avatar
Radhika2605
Icon for Helper II rankHelper II
5 years ago
Solved

Need help with measure

Hi Everyone,   I am working on an olympics data set and I am trying to find the top 10 atheletes using dax measure but instead of giving 10 results it is returning more than 10 results.    Dax me...
Need Help
  • ryan_mayu's avatar
    ryan_mayu
    5 years ago

    Radhika2605 

    that depends on how you want to choose the top 10 when total medals is dpulicated.

    let's say by name.

    _name=max( Athlete[Name] )

    _rank=RANKX( ALL( Athlete[Name] ), [Total Medals], , DESC ) +RANKX( ALL( Athlete[Name] ), _name,DESC)/10

    then you will get no duplicated rank.

  • ryan_mayu's avatar
    ryan_mayu
    5 years ago

    Radhika2605 

    it looks you have hundreds of names. pls try to change /10 to /100 or /1000