Skip to main content
This is lesson 7 of 7 in this module Course 62% complete
Prev Skip

Optimizing DAX Performance

Premium Content

Sign in with your account or sign up to access this lesson.

Sign In Sign Up

Tips and tricks for optimizing DAX performance including using variables (VAR) for readability and speed, the Performance Analyzer tool for benchmarking query times, and replacing FILTER with KEEPFILTERS for dramatic speed improvements.

Previous Next Module
Previous Module Create Calculations with DAX
This Module Advanced DAX Concepts
Advanced DAX Concepts
Advanced DAX Concepts
The CALCULATE Function
The CALCULATE Function
Using Inactive Relationships with DAX
Using Inactive Relationships with DAX
Semi-Additive Measures
Semi-Additive Measures
Date Tables and Time Intelligence
Date Tables and Time Intelligence
DAX Filter Functions: FILTER and CROSSFILTER
DAX Filter Functions: FILTER and CROSSFILTER
Optimizing DAX Performance
Optimizing DAX Performance
Next Module Create Reports