Optimization

VIDEO

DAX Studio 2.7 – Improved Debug Experience

DAX Studio 2.7 largely improved the debug experience by adding several feature described in this video: Tooltips for column statistics, capture all queries, and generate dependent measures. How to download DAX Studio (free and open source).

ARTICLE

Measuring the dictionary size of a column correctly

This article explains how to correctly measure the dictionary size of a column in a model created in Power BI, Power Pivot, or Analysis Services Tabular.

ARTICLE

How to compute index numbers at top speed

This article presents different techniques to compute a rownumber column in DAX based on a specific ranking, comparing slow and optimized approaches.

ARTICLE

Propagate filters using TREATAS in DAX

This article describes how to create a virtual relationship in DAX using the TREATAS function, which is more efficient than approaches based on INTERSECT or FILTER.

ARTICLE

Analyze DirectQuery requests using DAX Studio

This article describes how DAX Studio can analyze the SQL queries sent to a relational database by Power BI or Analysis Services Tabular in DirectQuery mode.

ARTICLE

Physical and Virtual Relationships in DAX

DAX calculations can leverage relationships present in the data model, but you can obtain the same result without physical relationships, applying equivalent filters using specific DAX patterns. This article show a more efficient technique to apply virtual relationships in DAX expressions.

ARTICLE

Optimizing DAX expressions involving multiple measures

Writing measures referencing other measures is in general a good idea that simplifies the DAX code, but you might face specific bottlenecks. This article describes which performance issues might arise when different measures aggregate the same column using different filter arguments, and how to improve efficiency of your DAX code.

ARTICLE

Filter Arguments in CALCULATE

A filter argument in CALCULATE is always an iterator. Finding the right granularity for it is important to control the result and the performance. This article describes the options available to create complex filters in DAX.

ARTICLE

Security Cost in Analysis Services Tabular

Applying security roles to a SSAS Tabular database might impact query performance. This article describes existing issues and possible workarounds. This is an advanced article, a good knowledge of storage engine and formula engine is required.

ARTICLE

Optimize Hardware Settings for Analysis Services Tabular

Hardware and virtualization settings have a big impact on Analysis Services Tabular performance. This article describes best practices for the most important settings to check.