cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
MP-iCONN
Frequent Visitor

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!




View solution in original post

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
PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!