Next Gen Data Learning – Amplify Your Skills

Blog Home

Blog

Evaluation Context In Power BI DAX

by | Power BI

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 more advanced, can your formulas actually have multiple contexts working at the same time?

Changing Context Within A Formula

Having multiple contexts is not that complicated, and I will show you this through an example.

First of all, we need to always understand what the evaluation or initial context is.

You need to have a great understanding of how context works within your formula.

Otherwise, you would sometimes have no idea where your results are coming from eventually.

In this example, the evaluation context is rather simple since it is simply the contents of the table.

Date and Total Sales table - Power BI Evaluation Context

But what if I wanted to calculate a running total here?

To do this, I will create a measure first and call it 30 Day Running Total. Then, I will put a CALCULATE function in my next line.

I will cover the CALCULATE function in detail in a later section, but essentially it calculates any expression we put inside and allows us to change the context of the calculation within a measure.

Creating New Measure for CALCULATE - Evaluation Context

CALCULATE will become your most used function by far since it is the most important function in DAX.

To proceed, I am going to calculate the Total Sales column but I want to calculate it in a different context.

Calculating Total Sales - Evaluation Context

I will use the FILTER function which allows me to create a filter in the new context that I want.

FILTER allows me to put a table inside it, but you do not have to put an actual table since you can also use a table function like in this example.

Using FILTER Function - Power BI Evaluation Context

I will then bring in the new measure to the table and put it in visualization for easier understanding.

30 Day Running Total Measure and Visualization - Power BI Evaluation Context

Logically speaking, we get the running total for each specific day by looking back from that day to thirty days prior and then summing all of them up.

This is important with regards to context since we have the evaluation context first through the Date column, but then we change the context to calculate the Total Sales in a new environment through a formula.

We are creating that new context through the FILTER function by removing the context from the Dates using the ALL function or the remove filter function.

Explaining the Function of ALL(Dates) - Evaluation Context

After removing the filter from any date, I will then work through every single date and look at the thirty day window from that specific date through this part.

Getting the Thirty Day Window - Evaluation Context

You can now see that we have created a different context within the formula itself.

Importance Of Understanding Evaluation Context

Understanding the evaluation context at every single point in time is very important. It gets more advanced since there are a lot of ways that we can change the context to calculate something different.

However, as you get deeper into Power BI, it also opens up a new world of opportunities where your formulas would not unnecessarily be long and complex.

Knowing these concepts would enable you to write things more efficiently wherein complex calculations could be done with a simple formula.

***** Related Links *****
Understanding Evaluation Context In Power BI
Explaining Row Context In Power BI
Introduction To Filter Context In Power BI

Conclusion

This article is simply an introduction about how you can change the context to write efficient formulas.

There are a lot of applications for context so hopefully, you are excited to see what you can achieve through the formula combinations and patterns that you can create.

Let us round off this section and move on to more key ideas and functionalities when utilizing DAX functions.

All the best,

Sam

[youtube https://www.youtube.com/watch?v=sz7yW06scgk&w=784&h=441]

Related Posts