cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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 Employee

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 Employee

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 Employee

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

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

#### Power BI Monthly Update - August 2024

Check out the August 2024 Power BI update to learn about new features.

#### Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

#### Fabric Community Update - September 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors