Category: DAX

Explaining Row Context in Power BI

I have found out that most people get confused in regards to understanding how DAX works in row context. This is because row context can be quite complicated and unnecessarily so. So we’re going to touch on row context throughout this article. The way I think about row context is through iterations or iterating functions.

Continue reading

Introduction to Filter Context in Power BI

Filter context is one of the major topics that any Power BI user should initially learn about, especially if you want your DAX calculations to work effectively. In this article, I will run through the filter context. Every DAX formula is calculated in a two-step process. DAX Formula: A Two-Step Process The first step is

Continue reading

Understanding Evaluation Context in Power BI

The most important concept in understanding DAX is context. There are three main types of context: the evaluation context, the filter context, and the row context. When DAX calculates something in Power BI, it works via a two-step process. At first, it evaluates the context it is currently in. Once it has done that, it

Continue reading

Extracting Unique Insights In Power BI Using Ranking DAX Measures

In this blog, I showcase ranking DAX measures to analyse something really practical and get amazing insights inside Power BI. It’s to work out the total sales of my top 3 salespeople based in any region. A really interesting insight, right? It might seem relatively intuitive, but actually implementing this inside of Power BI is

Continue reading

Power BI Customer Attribution Analysis Using Advanced DAX

We’re going to get advanced today. We’re going to really dive deep into customer churn: new customer and lost customer analysis in Power BI. Another term for this is attrition analysis because we want to see how our customer are churning, how many of our customers are coming on board and buying our products, how

Continue reading