Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
Solved! Go to 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
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
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.
Thanks.
Oh, I figure it out. Thank you very much!!!
User | Count |
---|---|
98 | |
87 | |
77 | |
67 | |
63 |
User | Count |
---|---|
110 | |
95 | |
95 | |
64 | |
58 |