Forum Discussion
DAX Performance Tuning - Avoid using ALL
Hi, I've been out of the DAX game for a little too long I think :). I have a table as following : ccountId PartnerId Transactions FirstTransaction row_num Industry Private_Public Result ...
Have a look at how the Power BI team writes their code - examples are in the Quick Measures, or in the Performance Analyzer for visual queries. You will see a lot of SUMMARIZECOLUMNS and TREATAS etc.
Use DAX Studio to examine your query plan - look for excessive number of records. Then go to sqlbi.com and watch a couple of videos on how to optimize your DAX code.
If you want us to help here please provide meaningful sample data.