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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.