Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.
.Hi I need Help to sum up the all the values in the column (
=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 |
Solved! Go to Solution.
Total Absolute Value = SUMX(Table, ABS([Value]))
Thank you
Total Absolute Value = SUMX(Table, ABS([Value]))