I have measures that come in and out of favor for my reports. I'd like to save processing time when running the refresh queries, but don't want to delete them from the model entirely since they may be wanted again.
So I usually comment out the "real" measure and put a dummy value. DAX will strip comments if they're at the start or end of the expression so that's why I use the VAR construct
Does anyone else have this issue, and have a good solution for keeping the measures handy?
So I usually comment out the "real" measure and put a dummy value. DAX will strip comments if they're at the start or end of the expression so that's why I use the VAR construct
Rich (BB code):
[My Archive Measure]:=
VAR Constant = 3
/*
Real measure syntax
*/
RETURN
ConstantDoes anyone else have this issue, and have a good solution for keeping the measures handy?
