Yield Calculation

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