O'Reilly logo

The Definitive Guide to DAX: Business intelligence with Microsoft Excel, SQL Server Analysis Services, and Power BI by Marco Russo, Alberto Ferrari

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 15. Analyzing DAX query plans

DAX is a functional language with a very fast execution engine. However, you can write the same calculation with different DAX expressions, possibly obtaining a different performance. In order to find a more efficient DAX expression, the first step is to identify the bottlenecks of an existing formula.

In this chapter, you will learn the architecture of the DAX query engine. You will also see how to obtain information about query plans and performance counters related to a particular DAX expression and how to read the information provided by Microsoft SQL Server Profiler and other tools. This knowledge is fundamental to optimize any DAX formula.

Introducing the DAX query engine

The DAX query engine accepts ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required