Add a constant column

[abdul26]

I have created a marix with the following details 

Rows: Company name 

Columns:   Week numbers 

Values - Values 

I wish to add a constant value threshold column. But if a create a measure with a constant value of 30, it will repeat for each column. (i.e. come under each week) 

I have attached a screenshot, the threshold column is what I am trying to add

I wish to add at once only.

Thank You! 

[Ashish_Mathur · Accepted solution]

Hi,

Assuming the figures under the Week column are derived via a measure (called Measure1), write this measure

Measure = if(hasonevalue(Data[Week]),[Measure1],30)

Hope this helps.

[Anonymous]

Hi @abdul26.

For the measure formula that you used on the value field, they will expand the calculations by current row and column groups.
I'd like to suggest you add a calculated column with a constant value, you can use it on matrix row fields to show the static values.

Regards,

Xiaoxin Sheng