DAX Calculation Issues

[databeta]

Hello,

I am creating a report about quality of products. I have Unique Serial Numbers that could have multiple products and each product has a work order number and Order quantity. I am using a matrix where they need to see the product numbers, WO, and Order quantity under the rows category. In the Columns I have a column called Area with area 1 area 2 and so on. Then in the values I need calculations to find Tested, Passed, Failed and Yield %. I have a column called Quality Status where it says ok, repaired, or not ok. The ok and repaired value are considered passed and not ok is considered failed. The Tested should be the passed and failed added together. For some reason the calculations I have now are giving me numbers that fall short compared to the numbers I should be getting. Almost as if it is missing data. What would be the best type of calculation to use for this?

Thank you in advance!

[V-yubandi-msft]

Hi @databeta , we’re still waiting for your response. Could you please share the sample data when possible? It will help us continue troubleshooting the issue.

Thank you.

[V-yubandi-msft]

Hi @databeta ,

We haven’t heard back from you yet. To help resolve your issue more effectively, could you please share some sample data? This will allow us to better understand and reproduce the scenario.

We appreciate your cooperation and look forward to assisting you further.

[PhilipTreacy]

@databeta 

Please supply your data, preferably the PBIX file.  Very hard to help without it.

Phil

[databeta]

Will this help?

[V-yubandi-msft · Accepted solution]

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.

[Ashish_Mathur]

Hi,

No, it doesn't.  Share data in a format that can be pasted in an MS Excel file.  Show the expected result there.

[ExcelMonke]

Hi Databeta,

In order to best help you, could you share samples of your data, the DAX you are using, any current visuals, and the expected outcomes?

Thanks