I often get questions about use cases for Azure Analysis Services. So I wanted to do a quick recap of the points I commonly discuss in these conversations, and have them readily available for the next conversation… As a bonus,…  Read more

This article provides information to help choose between DAX and Power Query when a table needs to compute additional columns.  Read more

This article describes how to analyze the performance of a DAX measure based on a DISTINCTCOUNT calculation and how to evaluate possible optimizations.  Read more

This article shows how to add an additional “other” row to the selection obtained using the Top N filter in a Power BI report.  Read more

This article describes a naming convention for temporary columns in DAX expressions to avoid ambiguity with the measure reference notation.  Read more

In 2015 I released the first version of VertiPaq Analyzer, a tool to quickly analyze the structure and data distribution of a Tabular model that can be used with Analysis Services and Power BI.  Read more

This article describes how to create a slicer showing the values of multiple columns, applying the filter on any of the underlying columns.  Read more

The second edition of The Definitive Guide to DAX is now available worldwide! This blog post explains why we felt the need to rewrite the book and describes what happens behind the scenes when producing a book.  Read more

This article describes different techniques to display the first three products for each category in Power BI. It includes considerations on how to adapt the technique to different models and requirements.  Read more

This article explains the precedence of calculation groups in DAX, needed whenever multiple calculation groups are present within the same model. Before starting, we suggest you read the previous articles in this series.  Read more