Measure that sums only positive values in matrix

[Syndicate_Admin]

Hey there;

I have an issue, I need that the measure sums only the positive vales

But when I use the switch statement to replane the negatives values with zero, works in the same way when sum the values

What I need is the following result:

I can't do it in a calculated colum because I'm using what-if parameter in the DAX formula.

[amitchandak · Accepted solution]

@Syndicate_Admin,[inven. Suggested] is a column

try a new measure

sumx(Table, if(Table[inven. Suggested] >0, Table[inven. Suggested] , blank()))

if [inven. Suggested] is a measure

sumx(values(Table[material]), if([inven. Suggested] >0, [inven. Suggested] , blank()))