Forum Discussion

abdul26's avatar
abdul26
Frequent Visitor
3 years ago
Solved

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 w...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    3 years ago

    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's avatar
Anonymous
Not applicable
3 years ago

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