DAX: To sum negative and positive numbers in a column

[JihyeHeo]

Hello, I need to sum the negative and positive numbers in a column.

For example, some orders used to be cancled after it is entered. I use sumx function but the it considers the negative values as the positive ones. Please help!

[Anonymous]

It would really help if you could phrase your problem/question in a more understandable and detailed way. For the time being it's not possible to understand what the issue is and what you want to calculate.

Thanks.

Best
D

[Anonymous]

Normal sum should have work.

Measure=sum(table[Amount])

Drag order number and measure in table visual.

Thanks & regards,
Pravin Wattamwar
www.linkedin.com/in/pravin-p-wattamwar

If I resolve your problem Mark it as a solution and give kudos.

[az38 · Accepted solution]

Hi @JihyeHeo 

what is your desired output?

if you need only sum of positive or only negative values try calculations like

CALCULATE(SUM([Sales Value]), [Sales Value]>0)

or 

CALCULATE(SUM([Sales Value]), [Sales Value]<0)​