Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Hi @Bharathi_99
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
User | Count |
---|---|
107 | |
88 | |
81 | |
76 | |
71 |
User | Count |
---|---|
112 | |
105 | |
96 | |
74 | |
66 |