Forum Discussion
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.
Sure thing.
Please give this a try and let me know how you get on, :)
5 Replies
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
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, :)
