Category: Data Modeling

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

Create Compelling Power BI Insights Fast For Financial Analysis

Learn Where Your Profit Comes From Fast in Power BI wSimple DAX

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,

Continue reading

Automatically Find Your Top 3 Salespeople Per Region Using DAX In Power BI

Create Dynamic Lists of Dimensions using DAX in Power BI

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

Continue reading

Discover Where Your Profit Growth Comes From: A Power BI Tutorial

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

Continue reading