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
Phil_Seamark's avatar
Phil_Seamark
Microsoft Employee
9 years ago

Hi vincentakatoh

 

I created the following calculated table that seems to make the calculation a little easier

 

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

and then I added the following measure to the above table

 

Roll Yeild = PRODUCT([Yield])

I can then use the new table to create this matix