Adding calculated columns to matrix visual

Hi Anonymous ,

I'm assuming that when you refer to calculated columns is a new column on the matrix and not on the data correct?

Just as a reference when you refer to calculated columns in PBI we are refering to columns that are added to the dataset tables and not on the visuals, this columns can then be used on the visuals. This calculated columns will increase the size of your file off course.

In your case if you want to add information to your matrix based on the slicers selection you need ot add a measure, however this has different ways of calculating than a column since for the use of measures you need a summarization formula.

Example of a measure is 

Total Estimate = SUM(Table[National Estimate])

this will give you the same total as you have the estimate column but the important part of this is that I have to use the SUM formula to get a result based on context, that ocntext comes from filters, visual, information within the measures.

Please check this article with further explanation on columns and measures.

If you need assistance can you please share some more information about what you want to achieve, sample data and expected result.

Regards,

MFelix