Forum Discussion
Add a constant column
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!
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.
2 Replies
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
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.
