Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to Solution.
Sure thing.
Please give this a try and let me know how you get on, 🙂
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, 🙂
Hi Phil,
Super. What a clean and easy solution. Love the awesome response in this forum. Power Support, Power BI!
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)
)
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
100 | |
75 | |
73 | |
49 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |