Sum of Calculations

[Anonymous]

Hi,

if looking for simple = here Excel = sum(Value1;Value2)
Value = Calculation

I don´t want to use +/- ... cause prefix of value can be at least different.

What is the correct formula in dax?
Thanks  

[mhossain]

Hi @Anonymous 

If you don't want to use +/- then SUMX is the option will work smilar to excel, agree with @Greg_Deckler  in DAX this the solution if you want to go down that route.

But it's interesting if you want to sum the different measures, why you don't want to use + prefixes simple, please let me know.

[Anonymous]

Hi, 

Well, cause first of all i was to stupid.. i forget that i was also using a Flip... so that allows me to make negative always negativ and postiv always positiv... in that case i can always use + an have right result.

But at least, cause i like the formula sum(Value1;Value2;aso) cause in this case i my opinion is much saver, as working wiht + an -.

[harshnathani]

Hi @Anonymous ,

Incase you have multiple columns try this

Measure =  SUM('Table'[ColumnOne]) +SUM('Table'[ColumnTwo])

Regards,

Harsh Nathani 

[Greg_Deckler]

@Anonymous - This might help: SUMX( { [Value1], [Value2] },[Value])

If not:

Not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882

Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.

Also, this: https://community.powerbi.com/t5/Community-Blog/Excel-to-DAX-Translation/ba-p/1060991

[amitchandak]

@Anonymous ,Can you share sample data and sample output in a table format?

In power BI  it Sum of Column sum(Table[col1])

or sum(Table[col1]) +sum(Table[col2])