Select Top 10 in a table chart

[JuMacedo]

Hi,

I have a table chart that looks like this the one below. I have simplified the table and select only these 3 columns, because the other columns have only descriptive information and I don't think they will influence in the solution.

I need to create a second table chart that will show only the first 10 rows of this chart. I have tried to find a solution here in the community and the most common solutions presented is 

=If(Aggr(Rank(measure), dimension) < 10, dimension)

I have tried this solution, but unfortunately it doesn't work in my case as I can't use Rank by measure which in this case would be the column Score 2, as the table needs to sorted out by Score 1 first ASC, then Score 2 DESC.

Any other solution that would not implicate creating RowNo()?? Just to select the first 10 rows as the show below?

Id                        Score1     Score2

1dc99c98	4	-14700
1d324310	4	-15540
30c7a880	4	-15960
024ed83a	4	-16800
f17b0654	4	-18600
5121d367	4	-19140
7cf3971c	4	-19860
bfce3585	4	-20400
9bb1ca87	5	-8760
de1e4c9f	5	-9600
022abb90	5	-12480
a9785e6b	5	-12480
71858f27	5	-12660
fd952360	5	-13200
7679e811	5	-13560
eb031f8d	5	-13560
77374696	5	-14220
a9679f81	5	-14220
e32632b3	5	-14220
39566878	5	-14400
22fb0168	5	-14400
aefc43e4	5	-15060
d07570ff	5	-15060
ead5250e	5	-15060

[TauseefKhan]

Hi @JuMacedo,

Why do you want to show only the first 10 rows, on which criteria?

[JuMacedo]

Because this is the client requirement. First sort by Score1 ASC, then sort by Score 2 DESC and show only the first 10 alternativ.