Topic: DAX

        312 posts
blog post –

How to write DISTINCTCOUNTX in DAX

I received a question about how to implement the equivalent of a DISTINCTCOUNTX function in DAX. Well, such a function doesn’t exist in DAX, but imagine you want to write something like: The corresponding measure working in DAX is: In…  Read more

From SQL to DAX –

From SQL to DAX: Joining Tables

In SQL there are different types of JOIN, available for different purposes. This article shows the equivalent syntaxes supported in DAX and it was updated in May 2018.  Read more

article –

Using OR conditions between slicers in DAX

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

article –

Expanded tables in DAX

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