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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
RezaAzimi
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:

motorstar1.PNGmotorstar2.PNGmotorstar3.PNG

 

 

 

 

 

 

 

 

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?

1 ACCEPTED SOLUTION

I have fixed it 🙂

View solution in original post

4 REPLIES 4
austinsense
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

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.