Production Yield Calculation

[vincentakatoh]

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(ISERROR(M3),1,M3)

Differentiate between zero and "#DIV/0"

2) Manage to get this far using Power BI. 

Que: How to calculate roll yield? Sample data in link below. 

https://1drv.ms/f/s!ArjVwEnHONXNgQ-4Kt5T8IMJwg6W

[Phil_Seamark]

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

[vincentakatoh]

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

[Phil_Seamark · Accepted solution]

Sure thing.

Please give this a try and let me know how you get on, 🙂

https://wgtnpowerbi-my.sharepoint.com/personal/phil_wgtnpowerbi_onmicrosoft_com/_layouts/15/guestacc...

[vincentakatoh]

Hi Phil, 

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

[vincentakatoh]

@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)
)