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

To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.

Reply
Chandrashekara
New Member

To sum negative and positive numbers in a column

.Hi I need Help to sum up the all the values in the column (

sum negative and positive) i can sum based on condition separtly i should get total as 85,

=CALCULATE(
sumx(table,Value))
but i am getting ansewer as 70, But i should need ansewer as 85 can some one help me

 

Order NumberEntry DateValue
A02020-20-0110
A2020-03-01-10
A2020-03-0210
B2020-03-0220
C2020-03-0220
D2020-03-025
E2020-03-025
E2020-03-02-5
2 ACCEPTED SOLUTIONS
tamerj1
Super User
Super User

Hi @Chandrashekara 
Please try

=
SUMX ( 'Table', ABS ( 'Table'[Value] ) )

View solution in original post

_elbpower
Resolver III
Resolver III

Total Absolute Value = SUMX(Table, ABS([Value]))

View solution in original post

3 REPLIES 3
Chandrashekara
New Member

Thank you 

_elbpower
Resolver III
Resolver III

Total Absolute Value = SUMX(Table, ABS([Value]))
tamerj1
Super User
Super User

Hi @Chandrashekara 
Please try

=
SUMX ( 'Table', ABS ( 'Table'[Value] ) )

Helpful resources

Announcements
September Power BI Update Carousel

Power BI Monthly Update - September 2025

Check out the September 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

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