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

     

Syndicate_Admin's avatar
Syndicate_Admin
Administrator
3 years ago

Hello everyone

How can you add only positive values of a measure?

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

Rodrigo P