Forum Discussion
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...
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
i did a test. maybe you can create a new table and create the visual based on the new table.
Table = TOPN(10,'Table',RANKX(all('Table'[name]),rankx(ALL('Table'[name]),[_sum],,DESC)+RANKX(all('Table'[name]),[_name],,ASC)/10,,ASC))
