Usually I create a lot of measures and even use nested measures as well. But now I am wondering if thats a best practice approach. Should I use variables rather than nesting or referencing to other measures?
An example for calculating a simple ratio.
Approach 1 with nestes measures:
- Measure 1 = SUM( value 1 )
- Measure 2 = SUM( value 2 )
- Measure 3 = DIVIDE( Measure 2, Measure 1 )
Approach 2 with variables:
- Measure 1:
var 1 = SUM( value 1 )
var 2 = SUM( value 2 )
DIVIDE( 2, 1 )
What do you think?