Forum Discussion
Performance - Multiple measures and variables
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.
MFelix Thank you! I searched for this on SQLBI and somehow didn't come up with it. Much appreciated.
marcorusso So if I understand what you said here and in the article, multiple measures will probably result in multiple calls, so condensing via variables into one measure is probably better? (Unfortunately I'm on a work computer and can't install DAXQuery, so all I have is the Performance Analyzer)
As I said, is more complex than that. Variables could be useful to avoid multiple calculations within the same DAX expressions, but other than that it really depends on the overall query execution plan.