Matrix table with top 10 but show more than 10

[nganbla]

i have a pending issue and could not solve by myself.

as above matrix table, I showed customers, this month and same period month (last year). %delta sales (use measure).

I config to show top 10 based on %delta from bottom only.

but you can see it's show more than 10, it's show 15 customer because we have some same %deta value at ( 2 x 92.86%,  2 x 87.50%...)

the idea I want to show only 10. 

how can i config it?

[v-jayw-msft]

Hi @nganbla ,

Did amitchandak formula works for you?

According to your screenshot, you have 6 x -66.67% records, which record you want to show in top 10 records?

Best Regards,

Jay

[amitchandak]

@nganbla , In rank add Rand()/100

and then filter for TOP N Rank

New Rank = RankX(all(Table[Col]),[Measure]) + Rand()/100 

Top 10 = CALCULATE([Measure],TOPN(10,all(Table[Col]),[New Rank],ASC),VALUES(Table[Col]))