Forum Discussion
Weighted Average DAX code for calculating Performance OEE
Hello all forum gurus!
Very new to Power BI and I need your help! I have a formula in Excel that calculates the Overall Performance OEE for a machine using the weighted average of the column Standard Rate. I need to have the DAX code to be able to do the same thing for a report I am writing for supervisors. The excel formula is as follows: =((SUM(D:D)/(SUM(G:G))/(SUMPRODUCT(D:D,F:F)/SUM(D:D)))) The spreadsheet is below (hopefully) for reference. Thanks in advance for the help!!!
OEE1
Anonymous,
I think it its looking for * sign try if doesn't work check the link out:
WA OEEPerf = ((SUM('BusinessView Ignition_RunData'[Quantity_Actual])/(SUM('BusinessView Ignition_RunData'[RunTime])))
/(SUMX('BusinessView Ignition_RunData','BusinessView Ignition_RunData'[Quality_Actua]*'BusinessView Ignition_RunData'[StandardRate])/(SUM(UrTableName[Quality_Actual])))Regards
Abduvali
6 Replies
Hi Anonymous,
It's almost the same but instead of the actual range you have to provide the Table and the Column names there is a similar post with a solution provided check it out:
Hope this helps if not let me know.
Regards
Abduvali
Abduvali - First, Thanks so much for your quick reply!!!
Trying your formula and I am getting the squiggly red lines under the second portion after the / symbol Highlighted in red.
WA OEEPerf = ((SUM('BusinessView Ignition_RunData'[Quantity_Actual])/(SUM('BusinessView Ignition_RunData'[RunTime])))
/(SUMX('BusinessView Ignition_RunData','BusinessView Ignition_RunData'[Quality_Actua]),'BusinessView Ignition_RunData'[StandardRate])/(SUM(UrTableName[Quality_Actual])))Any wisdom to share there?