DAX Calculation Issues

Hi databeta ,

Thanks for sharing the screenshots they give a idea of what you're working on.
However, to understand why the numbers are coming out lower than expected, we’ll need a bit more usable sample data.

Could you please share

1. A small sample of your data (around 8–10 rows) in a format that we can copy into Excel plain text or a simple table is fine.
Please include the key columns like.

Unit BC, Quality Status, Product No, WO, Order Quantity, Area, etc

2. The expected results for Tested, Passed, Failed, and Yield % for that sample so we can compare and identify where the calculation is going off.

This will help us recreate your scenario and suggest the right DAX logic or corrections to your current measures.

Thanks. Looking forward to your sample data.