Forum Discussion

vincentakatoh's avatar
vincentakatoh
Helper IV
9 years ago
Solved

Production Yield Calculation

Hi,    Will like to calculate production roll yield.    1) Below is "Roll yield" calculation using excel for each Line1-Line4 =IF(ISERROR(D3),1,D3)*IF(ISERROR(G3),1,G3)*IF(ISERROR(J3),1,J3)*IF(I...
Need Help
vincentakatoh's avatar
vincentakatoh
Helper IV
9 years ago

Hi Phil, 

 

Can you attached the sample data? Thanks, as you can tell, I'm a newbie to Power BI and dummy to DAX. Will like to explore the calculated table in Power BI. 

 

Thanks

  • vincentakatoh's avatar
    vincentakatoh
    Helper IV
    9 years ago

    Hi Phil, 

    Super. What a clean and easy solution. Love the awesome response in this forum. Power Support, Power BI!

    • vincentakatoh's avatar
      vincentakatoh
      Helper IV
      9 years ago

      phil, 

       

      Help! If the original data has a column "testdate", how can I add the "date" colum to the new Table "Yield Roll Table".

       

      Tired to add "data[testdate]" in the DAX formula, but it messes up the "Yield" Calculation, giving a incorrect Yield results. 

       

      Yield Roll Table =
      SUMMARIZECOLUMNS(
      data[Area],
      data[Line],
      data[station],
      data[testdate],
      "Count of Pass",COUNTROWS(FILTer('data',[test results]="P")),
      "Count of Fail",COUNTROWS(FILTer('data',[test results]="F")),
      "Yield",DIVIDE([CountPass],[CountPass]+[CountFail],1)
      )