Forum Discussion
Dynamically Reference a Measure within another Measure
We want to do this as well. Our use case involves storing report metadata in a dimension we call "Layouts". The Layouts dimension defines how the rows of a report will look and behave. There are Level 1 to 3 columns on this dimension for hierachy purposes, but we also have CalcType and Calc1 to 4 columns. The CalcType dictate the behaviour of the measure based using DAX. Here are examples of CalcType behaviour we are testing now:
0 = Return Blank (for reports that need a blank row as a separator)
1 = Use foreign key listed for that row (e.g. Account Number)
2 = Use range of values
3 = Use measure (this is where your solution would be helpful - we would essentially specify a measure in the Calc1 field.)
4 = Divide (E.g. sum two separate values for a level and divide them - this is great for getting things like % of Revenue at a row level)