Understanding the difference between a row context and a filter context is the first and most important concept to learn to use DAX correctly. This article introduces the filter context.  Read more

Using ALLSELECTED with no arguments in a remote model later used in a composite model might produce unexpected results. In this article we examine the topic and provide the reasons why ALLSELECTED requires special attention.  Read more

This article describes how to return BLANK instead of zero in a DAX measure. Using this technique, you can remove rows in a Power BI matrix visual where the result of a measure is zero.  Read more

This article describes the small differences between INT and CONVERT in DAX that may end up returning different results in arithmetic expressions.  Read more

This article introduces the syntax to describe in a textual form the DAX expressions and additional properties of calculation groups.  Read more

This article describes the IN operator in DAX, which simplifies logical conditions checking whether a certain value belongs to a list of values.  Read more

When used in a composite model, calculation groups show a very unique behavior that a good DAX developer must understand well to build sound models. In this article we describe how composite models and calculation groups work together.  Read more