Forum Discussion
Dynamically Reference a Measure within another Measure
Does anyone know if it is possible to reference a measure dynamically within another measure? As an example, you want to bring back a measure if it matches the formatted value of a slicer. For exampl...
Thanks again Greg. I think this is essentially what i've already done, but in those links you sent over, you still need to do an IF/SWITCH statement in the end to ultimately tie the measures together. I was looking at a way around this, and thought if it could dynamically reference a measure based on text, then i could skip using SWITCH altogether
I don't think what you are describing is possible in DAX. For example, if you could have a table of labels and DAX expressions as text, you could use the label column in your slicer and the "measure" would execute the DAX expression for that row. That doesn't exist as far as I know.
Regards,
Pat
It would be nice to be able to reference measures within another measure using dynamic text strings.
