Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric 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 |
---|---|
85 | |
76 | |
73 | |
70 | |
56 |
User | Count |
---|---|
104 | |
99 | |
93 | |
78 | |
69 |