Get Top 20 rows based on another column

[sivareddy123]

Hello all I wonder if someone can help me.

I have a table of data which I would like to pull out the top 20 rows depending on a measure value. 

 Any advice would be fantastic

[Andy100Rob]

If you're not looking to write any code, then the filter functions might work for you.

Top N filter option

Not sure if you have used these before, so:

Select the table, then head over to the Visualizations pane, under the Filters options, I've selected Customer Number and then the filter type of Top N.

You can then select how many you wish to filter, so I've gone with the Top 20

Then I've dropped a measure, GP GBP, into the By Value option.

Hope this helps.

Andy

[v-lid-msft]

Hi @sivareddy123 ,

How about the result after you follow the suggestions mentioned in my original post?Could you please provide more details about it If it doesn't meet your requirement?

Best regards,

Community Support Team _ Dong Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[v-lid-msft]

Hi @sivareddy123 ,

If you want to pull out the 20 rows, we can just ues the following formula to create a calculated table, you can change the part of [Value]+[Value2] to yours, it will calculate for each rows in table.

Table 2 = 
TOPN(20,'Table',[Value]+[Value2],DESC)

BTW, pbix as attached.

Best regards,

Community Support Team _ Dong Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Washivale]

Hi @sivareddy123 ,

Try following Dax function to create a new table.

TOP20 = TOPN(20,SUMMARIZ(Table, Table[Column]), [Measure])

let me know if it works with your requirement.

Thank You,
Washivale