cancel
Showing results for
Did you mean:
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"

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

1 ACCEPTED SOLUTION
Microsoft

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

Proud to be a Datanaut!

5 REPLIES 5
Microsoft

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

Proud to be a Datanaut!

Helper IV

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

Microsoft

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

Proud to be a Datanaut!

Helper IV

Hi Phil,

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

Helper IV

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

Announcements

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.