Top N Function

[Anonymous]

Hi all,
I have Merge1 table, in that i have i_suplr , Good, Over, Bad are there
In another table I have LIFNR, ZZTPART is there
In third table I have LIFNR, Name1 columns are there
I have given relattionship between Merge1 table to 2nd Table with LIFNR
and ZZTPART in 2nd table to LIFNR in 3rd table

I want to see in table chart that good count, bad, count and over count for top 10 name1 based on ZZTPART
If i am adding only ZZTPARENT and NAME1 It's giving only top 10 Name1, when adding good count, under count and iver count, it;s giving other also instead of only top 10
For example 1012 ZZTPART Has Name1 Airbag Corportaion
But after adding good count measure it;s giving other Names from Name1

How to achieve it

[Ritaf1983]

Hi @Anonymous 

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...
Please show the expected outcome based on the sample data you provided.

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

 If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly