Forum Discussion
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 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?
JamieMcConaghy , Which one?
New measure = ([Intial Cost])+Sum(Table [Access Cost])
5 Replies
- amitchandak
Super User
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])
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])
- Ashish_Mathur
Hi,
Share the download link of the PBI file.
