How to sum two column fields?

[Anonymous]

Hello,

I have two column that i would like to add. One column is the result of a calculation field called goal events adjusted and the other one is a column called all goals.

I have been trying to add up these two columns but the result is wrong. 

I am using sumx as function somone have any suggestions?

Thank you.

[Tahreem24]

@Anonymous ,

It would be nice if you share some sample data of your scenario to understand the context.

[BA_Pete · Accepted solution]

Hi @Anonymous ,

If the two columns you are trying to add together are in the same table then:

To add a new sum column:

_summedValues = [column1name] + [column2name]

To add as a measure:

_summedValues = SUM(yourTable[column1name]) + SUM(yourTable[column2name])

If they are not in the same table then you must ensure the two tables are related, then you can do the following:

To add a new sum column:

_summedValues = yourTable1[column1name] + RELATED(yourTable2[column2name])

To add as a measure:

_summedValues = SUM(yourTable1[column1name]) + SUM(yourTable2[column2name])

Pete

[Anonymous]

Thank you for your help