Filter out negative numbers in a summarize measure

[MP-iCONN]

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:

Thank you for any help on this!

[ryan_mayu · Accepted solution]

@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 $$$]

)

[MP-iCONN]

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!

[ryan_mayu]

you are welcome