Improving DAX Measure Performance
Just as specific columns and relationships can be optimized for performance per the prior recipe, frequently used DAX measures can also be targeted for performance improvements. Existing DAX measures may contain inefficient data access methods that generate additional, unnecessary queries or that largely execute in a single CPU thread. Revising measures to better leverage the multi-threaded storage engine and to avoid or reduce unnecessary queries and iterations can deliver significant performance improvements without invasive, structural modifications to the model.
In this recipe, DAX queries executed by Power BI visuals are captured and analyzed using the Performance analyzer feature of Power BI Desktop. These queries are then further analyzed within DAX Studio.
Getting ready
To prepare for this recipe, follow these steps:
- Download and install DAX Studio: https://daxstudio.org/downloads/.
- Download and open the file
Improving...
