cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
JihyeHeo
Frequent Visitor

DAX: To sum negative and positive numbers in a column

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!

image.png

1 ACCEPTED SOLUTION
az38
Super User II
Super User II

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)​

do not hesitate to give a kudo to useful posts and mark solutions as solution
LinkedIn

View solution in original post

3 REPLIES 3
Anonymous
Not applicable

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
Not applicable

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
Super User II
Super User II

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)​

do not hesitate to give a kudo to useful posts and mark solutions as solution
LinkedIn

View solution in original post

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Are You Ready?

Test your skills now with the Cloud Skills Challenge.

Top Solution Authors