TOPN

[wesentadesse99]

Dear Team,

I want to know the bottom 10 rank of the follwoing data. The requirement is the  bottom 10 lowset performer student(%) but for those students have equal point(performance) we need to consider again the lowest bonus.

Student Name	Performance(%)	Bonus
Name1	30%	1
Name2	30%	3
Name3	30%	5
Name4	30%	6
Name5	30%	7
Name6	30%	9
Name7	30%	11
Name8	30%	12
Name9	30%	14
Name10	30%	16
Name11	30%	17
Name12	40%	18
Name13	50%	19
Name14	60%	20
Name15	70%	21
Name16	80%	22
Name17	90%	24

regards, 

[v-jialluo-msft · Accepted solution]

^{Hi @wesentadesse99 ,}

^{Please follow these steps:}

^{(1) Create a new table}

Table 2 = TOPN(10,'Table','Table'[Performance(%)],ASC,'Table'[Bonus],ASC )

Table 3 = TOPN(10,'Table','Table'[Performance(%)],DESC,'Table'[Bonus],ASC)

^{(2)Final output}

^{If neither table is what you need, please state the correct output.}

^{Best Regards,}

^{Gallen Luo}

^{If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.}

[wesentadesse99]

Thanks a lot.