cancel
Showing results for
Did you mean:

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

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

#### Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

#### Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

#### The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors