Getting top values and ranking them by percent

[Anonymous]

So i am making a top 10 table of total tourist by country this year and i need to rank them by percent difference between years.

right now i have them ranked by value, and now i should keep the top 10 an rank them by percent on the right
so it would look like this and ranking from 1-10

if i try to rankx the percent then there are higher percent values than these and they get ranked wrong.

[ryan_mayu]

@Anonymous 

 the percentage column is a measure?

maybe you can try this

Measure 2 = RANKX(ALL('Table'),[Measure],,DESC)

in the filter, set measure 2 is less than or equal to 10

[Anonymous]

then i get this, as u can see it ranked the % right, but then i lose top 10 highest values

[ryan_mayu]

have you tried to apply the filters?

[Anonymous]

seems like it

[ryan_mayu]

could you pls provide the pbix file?