Forum Discussion
Need help with measure
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.
it looks you have hundreds of names. pls try to change /10 to /100 or /1000
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
it looks you have hundreds of names. pls try to change /10 to /100 or /1000