topic Calculation of defect rate using the product of yield rate. in DAX Commands and Tips

Calculation of defect rate using the product of yield rate.

31311ko — Sat, 05 Apr 2025 17:32:28 GMT

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.

Re: Calculation of defect rate using the product of yield rate.

lbendlin — Sat, 05 Apr 2025 19:43:34 GMT

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

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

Re: Calculation of defect rate using the product of yield rate.

v-echaithra — Mon, 14 Apr 2025 11:23:43 GMT

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

Re: Calculation of defect rate using the product of yield rate.

v-echaithra — Mon, 21 Apr 2025 09:28:55 GMT

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

Re: Calculation of defect rate using the product of yield rate.

v-echaithra — Wed, 30 Apr 2025 05:32:32 GMT

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