This article describes how to implement in DAX a logical OR condition between the selection of two slicers of a Power BI report or of a PivotTable in Excel. By default, when relying on more than one slicer they are…  Read more

Expanded tables are the core of DAX; understanding how they work is of paramount importance. This article provides a theoretical foundation of what expanded tables are, along with fundamental concepts useful when reading DAX code.  Read more

This article describes how to use DAX Studio to capture DAX queries generated by Power BI. Analyzing DAX queries can be helpful to better understand performance issues, and to improve the writing of DAX queries.  Read more

This article provides a complete explanation of the behavior of the ALLxxx functions in DAX. When used as filters in CALCULATE, ALLxxx functions might display unexpected behaviors.  Read more

This article describes a reference Date table in DAX using a Power BI template. The same technique can be used in Analysis Services models. Download the latest version of the template in the Dax Date Template page.  Read more

DAX Date Template is a Power BI template file containing a fully-featured Date table. This template spares the user from writing the required DAX expression – as well as in setting the necessary properties to define display format, hierarchies, and…  Free download

If you import more than one table into Power BI or Power Pivot, you have a data model. When you have more than one table, you usually have relationships between tables. When you analyze data, you often have many choices…  Read more

ALLSELECTED is a powerful function that can hide several traps. This article is an in-depth analysis of the behavior of ALLSELECTED, explaining shadow filter contexts, what they are and how they are used by ALLSELECTED.  Read more

This article describes how to use variables to optimize the performance of DAX expressions containing multiple instances of the same measure or the same sub-expression.  Read more

This article explains how the context transition interacts with the filter arguments of a CALCULATE function in DAX. This is important in order to avoid unexpected results with complex calculations made in filter arguments.  Read more