How to SUM (add) two columns in same table

[sdhn]

Hello All,

How to SUM (add) two columns in same table?

for example:

Players , 

55

Audinces 

1000

I want to add both columns thru mesaure and create new column called Total.

Thanks 

[sdhn]

I created following mesaures

1)

Players #  = SUM('Table'[Players] )

2)

Audinces #  = SUM('Table'[Audinces ] )

Now i need to add both:

Total  = SUM('Table'[Remaining Desktops] +  .....   ?  

Help wil be appreciated. 

[v-jingzhang · Accepted solution]

Hi @sdhn 

If you need a calculated column to sum two column values in the same row, use 

Total 1 = 'Table (2)'[Players] + 'Table (2)'[Audinces ]

If you need a calculated column to sum all values in two columns, use

Total 2 = SUM('Table (2)'[Players]) + SUM('Table (2)'[Audinces ])

If you need a measure for Total, use

Total = SUM('Table'[Players] ) + SUM('Table'[Audinces ] )

Or

Total = [Players #] + [Audinces #]

Regards,
Community Support Team _ Jing
If this post helps, please Accept it as the solution to help other members find it.