Formula for calculating Mechanical Efficiency for a specific machine type

[Susan_Colyn]

Hi,

I need help with a Dax formula.

I have to calculate the Mechanical Efficiency and I have the formula for this but my data includes different machine types and I would like to add a type of filter to the formula, as I only want the Mechanical Efficiency for a certain type.

Her is my data - Location of the machine, Type (Filling machine or Downstream Equipment), Production Time, Equipment Stop Time

The formula I have currently for Mechanical Efficiency is

Is there a type of filter I add to this formula to only get the FM result.

Regards,

Susan

[HotChilli · Accepted solution]

A Measure would be (names may be different at your side)

MMEFM = SUMX(FILTER(MME, MME[objType] = "FM"), DIVIDE(SUM(MME[PT fm/de]), SUM(MME[PT fm/de]) + SUM(MME[EST fm/de])))

There are other ways to do it. Switch on 'Show items with no data' in a table visualisation to see the other object types

Am i right that it only makes sense in a row context?  If so, the calculated column would be

ColumnMMEFM = IF (MME[objType] = "FM", DIVIDE(MME[PT fm/de], MME[PT fm/de] + MME[EST fm/de]),0)

[Susan_Colyn]

Hi,

Thank you for assisting but I need more help, please.  I thought the formula worked but I still had 'FM" selected in the Page filter.  I just removed it and the result is incorrect.  It doesn't filter "FM".

I tried the IF formula and it only allows Measures after IF.  I received an error when using the Column name.  

Is there another formula I can use?

[Susan_Colyn]

Thank you, I used the SUMX formula and it works perfectly