Combining two columns in a table/matrix visual

[JamieMcConaghy]

I have a table that shows two columns of values (Initial Cost and Access Cost): one caluclated by a SUMX measure, and one just summing straight from the source data. Each column is empty when the other has values, and I am trying to merge them so that it only shows in one column. Is there a way to do this in the table/matrix, or do I have to create a new value/measure for this? If so, how can I sum them?

[Ashish_Mathur]

Hi,

Share the download link of the PBI file.

[amitchandak]

@JamieMcConaghy , You need a new measure = [Intial Cost]+[Access Cost] , if both are measure 

if they are columns 

New measure = sum(Table [Intial Cost])+Sum(Table [Access Cost])

[JamieMcConaghy]

One is a measure and one is a column, so I don't see how to combine them.

[amitchandak · Accepted solution]

@JamieMcConaghy , Which one?
New measure = ([Intial Cost])+Sum(Table [Access Cost])

[JamieMcConaghy]

Ah okay, that all looks good now. Thanks.