Weighted Average DAX code for calculating Performance OEE

[Anonymous]

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

[Abduvali]

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:

• https://community.powerbi.com/t5/Desktop/WEIGHTED-AVG/m-p/8690#M1506

Hope this helps if not let me know.

Regards

Abduvali

[Anonymous]

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?

[Abduvali · Accepted solution]

@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])))

• https://community.powerbi.com/t5/Desktop/WEIGHTED-AVG/m-p/8690#M1506

Regards

Abduvali

[Anonymous]

Abduvali - Thanks so much for the answer!   Got what I needed off the link and your answer combined!  Or at least that is what I got to work.   See below!

WA OEEPerf = ((SUM('BusinessView Ignition_RunData'[Quantity_Actual])/(SUM('BusinessView Ignition_RunData'[RunTime])))
/(SUMX('BusinessView Ignition_RunData',[Quantity_Actual]*[StandardRate]/(SUM([Quantity_Actual])))))

Thanks again!  

[Abduvali]

@Anonymous

You are welcome =D

[Anonymous]

I fixed the last Urtablename as well - still have squiggly lines....