Tag: filter context

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. You may watch the full video of this tutorial at the bottom of

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. You may watch the full video of this tutorial at the bottom of this blog. In this article, I will run through the filter context. Every DAX formula

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. You may watch the full video of this tutorial at the bottom of this blog. When DAX calculates something in Power BI, it works via a two-step process. At

Continue reading

Power BI Percent Of Total – Using CALCULATE Statement

Power BI percent of total is a really common calculation that we require quite often. This is great to quickly show where the larger portion of results sit versus the entire population. Completing this in Power BI does not require much written code, but it does require some understanding. It will generally be one of the

Continue reading