Skip to main content
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Helper I
Helper I

SUM if with certain criteria

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?


I have fixed it 🙂

View solution in original post

Impactful Individual
Impactful Individual

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

Austin is VP Operations at PowerPivotPro and a professional self-service enthusiast 🙂

these are measures:)

They look like calculated columns

Austin is VP Operations at PowerPivotPro and a professional self-service enthusiast 🙂

I have fixed it 🙂

Helpful resources

July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.


Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors