ALLSELECTED is an extremely complex function to use in DAX. In this article, we provide an introduction to ALLSELECTED and its main use cases, leaving the most intricate details to more advanced articles.  Read more

RELATED and its companion function RELATEDTABLE, are two common DAX functions that are required when using a row context with relationships. In this article we describe why and when to use these two functions.  Read more

This article shows how to manipulate the filter context to create a report with the sales made to a specific customer segment, before and after a selected month.  Read more

Using variables in DAX makes the code easier to read, faster, and easier to debug. In this article, we discuss how and when to use variables, along with why they are so important in any DAX expression.  Read more

Rolling averages are a very common calculation used to smooth out charts. This article shows how to compute a rolling average taking into account only the working days.  Read more

This article describes how to hide measures from a group of users by leveraging object-level security in Power BI and Analysis Services.  Read more

This article explains how to use KEEPFILTERS to intersect instead of override an existing filter context in DAX. Using KEEPFILTERS simplifies the code and improves performance.  Read more

This article analyzes the fields parameters feature in Power BI, unveiling some of the internals of its implementation.  Read more

Context transition is one of the most obscure topics for DAX newbies. In this article we introduce context transition, its effects, and how to leverage it rather than be scared of it.  Read more

CALCULATE is the most powerful and complex function in DAX. In this article, we provide an introduction to CALCULATE, its behavior, and how to use it.  Read more