Static value in Measures

We are creating a report that has 2 static values that will displayed in a 2 diff columns and a 3rd calculated field that will used these 2 values for calculation.

So the question, how do i create a calculated filed that will have a static value?

I understand that you want a calculated measure which returns a constant value regardless of selected dimensions and its usage in the report. In this case, create new calculated measure in Measures and enter a required value (it’s like setting a value to an argument). And, in further calculations, you may refer to this calculated measure instead of a hardcoded number.

For example, to get constant value 42, in the calculation part enter 42 (see picture below).

Then, in further calculations, you may refer to calculated measure [Measures].[Cons 42] instead of a numeric value “42”.

Zane /