Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Adding up only negative values

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 da...
Need Help
  • v-gizhi-msft's avatar
    v-gizhi-msft
    6 years ago

    Hi,

     

    Please try this column:

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

    The result shows:

     

    Best Regards,

    Giotto Zhi

     

amitchandak's avatar
amitchandak
Super User
6 years ago

Try like

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