Yield Calculation

[Anonymous]

Hi,

I just start using power BI and try to figure it out how to do distinctcount. Below is my data set.

I need to calculate the yield by

- test name

- group (group can be first, only, last). 

- if one parameter fail, the whole unit will be fail.

Currently, I can do it by calculate Qty and Fail Qty.

but I will need this function to work if I want to group the "Group" together. So, I can compare yield between

group1: first and only

group 2: last and only.

what is the best way to handle this situation ?

Thanks

[v-henryk-mstf]

Hi @Anonymous ,

You can try creating calculated tables to achieve this effect.

CALCULATE & CALCULATETABLE - What's The Real Diffe... - Microsoft Power BI Community

Using calculated tables in Power BI Desktop - Power BI | Microsoft Learn

If the problem is still not resolved, please provide detailed error information and test data. Looking forward to your reply.

Best Regards,
Henry

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.