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
Category: Data Modeling
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
In this particular example, I’m going to show you how you can discover profit insights quickly with Power BI. Profits are key for any business, right? You want to understand how your profits are being derived, where they’re coming from, and why you’re getting the results that you are. With Power BI, using intuitive techniques,
There’s so much you can do with DAX in Power BI, and one of these things is for you to be able to find your top 3 salespeople for each region automatically. Picture this too familiar scenario…. You are in a meeting and asked about your sales territories. Who are your top three sales people
In this Power BI tutorial, I dive into what’s perhaps a very niche insight. But don’t let that close you off to using this technique — there are plenty of ways to implement this across a range of scenarios. The key is to understand each different part and transfer them across similar elements in your