Forum Discussion
Solved
Combining two columns in a table/matrix visual
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 oth...
JamieMcConaghy , Which one?
New measure = ([Intial Cost])+Sum(Table [Access Cost])
amitchandak
Super User
Super UserJamieMcConaghy , 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])
One is a measure and one is a column, so I don't see how to combine them.
- amitchandak
JamieMcConaghy , Which one?
New measure = ([Intial Cost])+Sum(Table [Access Cost])Ah okay, that all looks good now. Thanks.