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....

  • 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