SUM if with certain criteria

[RezaAzimi]

Hi all,

I have cost data for three pump motor components (stator, rotor and rotorcan) that I am working on. I want to plot the sum of standard unit cost for all of these three components (called motorstar hereafter) for each pump.  FYI some pumps the motorstar consists of stator and a rotor with shaft and hence no rotorcan. I made some measures that looks like this:

but I know that these measures are not calculating the results that I want because I see that the if function does not work as I thought and sometimes it only sum the value of one component and return the value of that component. So the main issue is that it only measures the cost of one component and not for two or three components. 

somebody who can help me on this?

[austinsense]

I see your formulas - are these calculated columns or measures?

[RezaAzimi]

these are measures:)

[austinsense]

They look like calculated columns

[RezaAzimi · Accepted solution]

I have fixed it 🙂