Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

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 St...
Need Help
  • Abduvali's avatar
    Abduvali
    8 years ago

    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

Anonymous's avatar
Anonymous
Not applicable
8 years ago

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?

Anonymous's avatar
Anonymous
Not applicable
8 years ago

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