Calculation of defect rate using the product of yield rate.

[31311ko]

Could you please teach me how to calculate DAX?

When calculating the defect rate,

I want to calculate it as "1-Product of yield rate for each inspection process on that day" instead of "defective number / ProductionQuantity",but I am not getting the expected result.

Specifically, in the attached table visual, I would like the defect rate on March 5th to be

1-0.99792*0.99898= 0.00309 = 0.31%.

Currently used DAX

・1-Product of yield rate =1-[Product of yield rate]

・Product of yield rate = CALCULATE(PRODUCTX('table',[Yield rate]))

・Yield rate= 1-[Defect rate]

・Defect rate =DIVIDE([DefectiveNumber], [ProductionQuantity], 0)

Thank you in advance.

[v-echaithra]

Hi @31311ko ,

As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided for the issue worked? or Let us know if you need any further assistance?
If our response addressed, please mark it as Accept as solution and click Yes if you found it helpful.

Regards,

Chaithra E

[v-echaithra]

Hi @31311ko  ,

we wanted to kindly follow up to check if the solution provided for the issue worked? or Let us know if you need any further assistance?
If our response addressed, please mark it as Accept as solution and click Yes if you found it helpful.

Regards,

Chaithra

[v-echaithra]

Hi @31311ko ,

As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided for the issue worked? or Let us know if you need any further assistance?
If our response addressed, please mark it as Accept as solution and click Yes if you found it helpful.

Regards,

Chaithra E

[lbendlin · Accepted solution]

1-Product of yield rate for each inspection process on that day

on that day, regardless of line?   You can use REMOVEFILTERS for that.