calculate the sum of accumulated value

[Anonymous]

Hi, I need help to summarize the erro ABS.

As you can see the sum of erro abs IA is wrong shoud be 30.968

[v-lid-msft]

Hi @Anonymous ,

How about the result after you follow the suggestions mentioned in my original post?Could you please provide more details about it If it doesn't meet your requirement?

Best regards,

[v-lid-msft · Accepted solution]

Hi @Anonymous ,

We can use the following measure to meet your requirement.

Measure = CALCULATE(SUM('Table'[value]),'Table'[value]>0) - CALCULATE(SUM('Table'[value]),'Table'[value]<0)

If it doesn’t meet your requirement, could you please show the exact expected result based on the table that we have shared?

BTW, pbix as attached.

Best regards,