cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
vincentakatoh
Helper IV
Helper IV

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

Differentiate between zero and "#DIV/0"2017-04-24 22_55_21-PowerBI 0424 - Excel.png

 

2) Manage to get this far using Power BI. 

2017-04-24 22_57_47-Production Yield Calculation 0424 - Power BI Desktop.png

 

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

 

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

1 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...

 

 


To learn more about DAX visit : aka.ms/practicalDAX

Proud to be a Datanaut!

View solution in original post

5 REPLIES 5
Phil_Seamark
Microsoft
Microsoft

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

 

yeld.png

 

 


To learn more about DAX visit : aka.ms/practicalDAX

Proud to be a Datanaut!

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

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...

 

 


To learn more about DAX visit : aka.ms/practicalDAX

Proud to be a Datanaut!

View solution in original post

Hi Phil, 

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

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

Helpful resources

Announcements
MBAS on Demand

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

July 2021 Update 768x460.png

Check it out!

Click here to read more about the July 2021 Updates

Power Query PA Forum 768x460.png

Check it out!

Did you know that you can visit the Power Query Forum in Power BI and now Power Apps

Top Solution Authors
Top Kudoed Authors