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

Abduvali's avatar
Abduvali
Skilled Sharer
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 - 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's avatar
    Abduvali
    Skilled Sharer
    8 years ago

    Anonymous

     

    You are welcome =D