To sum negative and positive numbers in a column

[Chandrashekara]

.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 Number	Entry Date	Value
A0	2020-20-01	10
A	2020-03-01	-10
A	2020-03-02	10
B	2020-03-02	20
C	2020-03-02	20
D	2020-03-02	5
E	2020-03-02	5
E	2020-03-02	-5

[tamerj1 · Accepted solution]

Hi @Chandrashekara 
Please try

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

[Chandrashekara]

Thank you 

[_elbpower · Accepted solution]

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

[tamerj1 · Accepted solution]

Hi @Chandrashekara 
Please try

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