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

ryan_mayu's avatar
ryan_mayu
Icon for Super User rankSuper User
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.

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

    Hi ryan_mayu 

    Thank you so much for your prompt response.

     

    Could you please explain the logic you used a bit as I am unable to comrehend it (sorry still at beginner). Also, I tried to use what you suggested but it is giving error as shown in the screenshot below: 

     

     

    Thanks

    Radhika

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

        Hi ryan_mayu,

         

        Thanks for you effor in sending the solution. I did tried it but the issue is it is still not giving the correct result. the result which I am getting is on the left. 

         

        Right hand table is the table which shows the total number of medals won and I have arrange it in descending order according to the number of medals. It shows that the highest medal won is 58, then 39 and then 38. 

         

        But the tabel on the left only has values for athelete names starting from alphabet A. I think it is arranging it in alphabetical order or something. 

         

        how should the solution which you have provided needs to be refined for it to work properly? 

        Thanks in advance

        Radhika