Calculated Column sum of values in excel and DAX

[sarav93]

 In excel,sum(-18-17+0+0+397982-557220+0+0+0+0+0+0-2108965) = -2268238, i got the sum as -2268238 but in power bi the value is been changed. how to acheive the same as adding positive values and negative values to achieve the same sum using power bi

[Kaviraj11 · Accepted solution]

Create a Measure

Total= CALCULATE(SUM(ColumnName))

[v-kaiyue-msft · Accepted solution]

Hi @sarav93 ,

Your solution is great, @Kaviraj11 . Here I have another idea in mind, and I would like to share it for reference. 

Based on your description, I created these data.

1. if you put the data in a table visual object and set the aggregation of num to sum, then the total row will automatically display the sum.

2. you can also create measure to display as @Kaviraj11  said.

Measure =
SUM('Table'[num])

By using measures, you can create some of the most powerful data analysis solutions in Power BI Desktop. measures help you by performing calculations on measures help you by performing calculations on your data as you interact with your reports.

More detailed information can be found at the link:
Tutorial: Create your own measures in Power BI Desktop - Power BI | Microsoft Learn
Context in DAX Formulas - Microsoft Support

If your Current Period does not refer to this, please clarify in a follow-up reply.

Best Regards,

Clara Gong

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Kaviraj11 · Accepted solution]

Create a Measure

Total= CALCULATE(SUM(ColumnName))