Adding up only negative values

[Anonymous]

Hi All,

I am trying to add up a column by only adding up the negative numbers and if there are positive numbers, just setting those to 0 so they don't affect the final total.  Here is some sample data:

As you can see - the total is -311 whereas if the positive values in here were excluded, the total would be around -850 or so.  I believe it needs to something to say If Sales >0, then 0, otherwise sum up the column but i'm unsure as how to put it together.  Any help would be appreciated.

Thanks!

[Syndicate_Admin]

Hello everyone

How can you add only positive values of a measure?

I've been trying to figure this out for days.

Rodrigo P

[v-gizhi-msft · Accepted solution]

Hi,

Please try this column:

Column = IF('Table'[Sales]>0,0,'Table'[Sales])

The result shows:

Best Regards,

Giotto Zhi

[Tahreem24]

@Anonymous ,

Create below DAX measure:

Measure  = CALCULATE(SUM(Table[Sales]),Table[Sales]<0)

Don't forget to give thumbs up 👍 and accept this as a solution if it helped you.

[amitchandak]

Try like

sumx(Table,if(table[sales]<0,table[sales],0))