Forum Discussion
Calculate Defect Rate
Hello, I've 2 tables. TABLE 1: Defect Data Table ITEM Qty 1A 8 2A 4 3A 4A 5 5A 6A 6 7A 6 TABLE 2: Item Receive Data Table Item Qty ...
Hi v-lili6-msft,
I already had an answer in table (by having filter: Qty (defect table) and Qty (Receive Table) is NOT BLANK) but to have it this defect rate by Vendor on line and bar chart, it's calculating total sum of QTY on both the table and showing a wrong result.
As shown in below image, I got the result in table (23.43 % is expected outcome) but not on the chart (05.16 % not the correct one).
Hope this help. Can you please advise?
hi, Anonymous
Could you share your sample pbix file for us to have a test, It is difficult to find out the reason from the screenshot.
You can upload it to Dropbox and post the link here. Do mask sensitive data before uploading
Best Regards,
Lin