topic Re: DAX: To sum negative and positive numbers in a column in DAX Commands and Tips

DAX: To sum negative and positive numbers in a column

JihyeHeo — Thu, 05 Mar 2020 07:33:35 GMT

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!

Re: DAX: To sum negative and positive numbers in a column

az38 — Thu, 05 Mar 2020 08:18:27 GMT

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)

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

Re: DAX: To sum negative and positive numbers in a column

Anonymous — Thu, 05 Mar 2020 09:49:50 GMT

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.

Re: DAX: To sum negative and positive numbers in a column

Anonymous — Thu, 05 Mar 2020 12:07:45 GMT

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