Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi
I need some advice to calulate supplier PPM from two tables. The calulation is as followed - Defects / Qty Received * 1000000 = Supplier Code PPM from the two tables below. I have a sample format report (under the table image) by month that I am trying to recreate using Power Bi Matrix table but been unsuccessful. Any guidance would be helpful.
Solved! Go to Solution.
Hi @Anonymous ,
I can find the supplier code as relationship key, but it seems like lots of records has same supplier code. Is there any other fields to help records correct mapping?
If your requirement is for whole records, you can try to use following formula:
Measure = CALCULATE ( SUM ( TableB[Defects] ), FILTER ( ALLSELECTED ( TableB ), [Supplier Code] IN VALUES ( TableA[Supplier Code] ) ) ) / CALCULATE ( SUM ( TableA[Defects] ), ALLSELECTED ( TableA ), VALUES ( TableA[Supplier Code] ) ) * 1000000
Regards,
Xiaoxin Sheng
Hi @Anonymous ,
I can find the supplier code as relationship key, but it seems like lots of records has same supplier code. Is there any other fields to help records correct mapping?
If your requirement is for whole records, you can try to use following formula:
Measure = CALCULATE ( SUM ( TableB[Defects] ), FILTER ( ALLSELECTED ( TableB ), [Supplier Code] IN VALUES ( TableA[Supplier Code] ) ) ) / CALCULATE ( SUM ( TableA[Defects] ), ALLSELECTED ( TableA ), VALUES ( TableA[Supplier Code] ) ) * 1000000
Regards,
Xiaoxin Sheng
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
94 | |
82 | |
66 | |
58 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |