Understanding Row Context in DAX and Power BI

Hey all! In my latest YouTube video I discuss Row Context in Data Analysis Expressions (DAX). Row context by itself is a very easy concept but I’ve seen, quite consistently, that many people are confused by row context and most of this confusion is a result of other concepts like nested row context and evaluation context. I will be tackling those topics in future posts, but for now, let’s take a peek at row context.

What is Row Context in DAX?

Row context is created by calculated columns and iterator functions in DAX. This is because these operations work on one row at a time when performing expressions. A common side effect of row context is that the active filter in your data model is disabled by default. I discuss this behavior in the video below as well as how to work around it using navigation functions.

What are Navigation functions in DAX? (Related and RelatedTable)

RELATED and RELATEDTABLE are functions that allow the developer to use the existing active relationship when a row context is present and the filter has been disabled. Which one you use depends on which side of the relationship you are on. For example, use RELATED when you are on the many side of the relationship and RELATEDTABLE when on the one side of the relationship.

Thanks for watching!

One thought on “Understanding Row Context in DAX and Power BI

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s