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”.
Best,
Zane / support@eazyBI.com