Multiplication Between Columns in the same matrix

[ryanyeh1123]

Hello,

I am currently trying to caculate the overall yield rate in the same matrix (different stage), but when I have no ideas to write the Dax.

From this table, I want to do is multiply 97.5%*95.35%*100%*98.9%.

Can I please have some help with how I have the correct formula?

Thanks.

[ExcelMonke · Accepted solution]

Hello,

One way you can consider doing this is with the following:

Measure = 

VAR _FLB = Your Calculation
VAR _FCT = Your Calculation
VAR _Cycle = Your Calculation
VAR _Run = Your Calculation

RETURN
_FLB * _FCT * _Cycle * _Run

For extra validation, I would ensure each variable computes the result you expect. I'd recommend Returning each variable first before you do the full multiplication. i.e.

Measure = 

VAR _FLB = Your Calculation
//VAR _FCT = Your Calculation
//VAR _Cycle = Your Calculation
//VAR _Run = Your Calculation

RETURN
//_FLB * _FCT * _Cycle * _Run

_FLB

And repeat for each variable so that you can trust you answer

[ryanyeh1123]

Thank you for your reply. However, I have a problem to appoint these variance respectively in different stage.

Ex. How can I appoint the Y/R % when stage in NR. FLB TEST.

My caculation is below.

Y/R % = DIVIDE(([Input Q'ty]-[Defect Q'ty]),[Input Q'ty])

Defect Q'ty = CALCULATE(COUNT(stage[#]),'stage'[Pass/Fail]="Fail")+0

Input Q'ty = COUNT(stage[#])

Thanks.

[ryanyeh1123]

Oh, I figure it out. Thank you very much!!!