In this tutorial, we’re going to take a look at a piece of DAX code. You may have already used something like this. Or, you may come across it and be confused about how this code works and how both Row Context and Filter Context seem to be interacting with each other in just a
In this post, I expand more on the evaluation context in Power BI DAX. You may watch the full video of this tutorial at the bottom of this blog. Evaluation context is also known as the initial context in Power BI. It is the environment from which your calculation is based on. To make things
In this article, we will review how to find the percent of the total calculation in Power BI. Although you might have already learned this from the other modules, reviewing it would be beneficial for its common usage in various scenarios. Percent Of Total In Total Sales To show you a simple example, we will
In this DAX tutorial, we’ll discuss context and its significance to understanding how DAX calculation engine works in Power BI. The idea of contexts in Power BI isn’t easy and it’s often overlooked. However, we need to remember that we always need to include the concept of context into our minds, especially when dealing with
In this tutorial, we’ll learn about evaluation context in DAX. Evaluation or initial context is the environment from which your dynamic calculation is based from. It’s important to understand how evaluation context works and how it affects your DAX calculation. So in the next section, I want to show you the different ways to create
