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.
Hi Anonymous,
This depends on what you need believe that you must make the measures and then test turn on the performance analyser to check what is the one that is getting poor results.
Has Anonymous you can also create some columns to make it faster to calculate but be aware that if you create columns your model and pbix file will grow in size and you may need to make some measure also depending on the final result you need.