Forum Discussion
Performance - Multiple measures and variables
This is not your basic "should I use a variable or measure" question. 🙂 I need to optimize variables and measures. I want to produce a measure that returns number of events this week and how that c...
Hi Anonymous ,
Check this post from SQL BI.
https://www.sqlbi.com/articles/optimizing-dax-expressions-involving-multiple-measures/
This is an article from marcorusso and he can help to clarify some of these more complex issues around if we should use variables, measures or columns.
marcorusso can you enlight us all with the information requested.
Thank you.
Hi Anonymous
I would create columns instead of measures for commoun cause in that case if the calculation is required by other visuals.
Once you have it in column it will be processed once and you can use it where ever you need.