Forum Discussion

ryanyeh1123's avatar
ryanyeh1123
Frequent Visitor
2 years ago
Solved

Multiplication Between Columns in the same matrix

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.

Need Help
  • ExcelMonke's avatar
    ExcelMonke
    2 years ago

    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

3 Replies

  • ExcelMonke's avatar
    ExcelMonke
    Impactful Individual
    2 years ago

    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's avatar
      ryanyeh1123
      Frequent Visitor
      2 years ago

      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.