Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

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
Community Champion
Community Champion

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
Community Champion
Community Champion

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

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors