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
MP-iCONN
Resolver I
Resolver I

Filter out negative numbers in a summarize measure

I have a measure I am trying to summarize and what I want to do is filter out the negative values.  

 

This is my measure I am using:

 

Total $ Test =
SUMX(
ADDCOLUMNS(
SUMMARIZE(
'Sales Orders',
'Sales Orders'[Sales Order ID],
'Sales Orders'[SO Line Nbr]),
"Total $$$",
CALCULATE([Total $ Unscheduled])
),
[Total $$$]
)
 
When I use DAX Studio to evaluate it I can see negative values in my Total $$ column.  Is there a way to filter out these negative numbers in this measure?
 
Here you can see the negative numbers:
MPiCONN_0-1631886107231.png

 

Thank you for any help on this!

 
1 ACCEPTED SOLUTION
ryan_mayu
Super User
Super User

@MP-iCONN 

maybe you can try

Total $ Test =
SUMX(
FILTER(ADDCOLUMNS(
SUMMARIZE(
'Sales Orders',
'Sales Orders'[Sales Order ID],
'Sales Orders'[SO Line Nbr]),
"Total $$$",
CALCULATE([Total $ Unscheduled])
),[Total $$$]>0),
[Total $$$]
)




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




View solution in original post

3 REPLIES 3
ryan_mayu
Super User
Super User

@MP-iCONN 

maybe you can try

Total $ Test =
SUMX(
FILTER(ADDCOLUMNS(
SUMMARIZE(
'Sales Orders',
'Sales Orders'[Sales Order ID],
'Sales Orders'[SO Line Nbr]),
"Total $$$",
CALCULATE([Total $ Unscheduled])
),[Total $$$]>0),
[Total $$$]
)




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Awesome, yes it worked!  I was using the filter after the calculate but not wrapping it in the statement like you did.  Thank you very much!

you are welcome





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




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.