From the course: Excel Business Intelligence: Power Pivot and DAX

Unlock this course with a free trial

Join today to access over 22,600 courses taught by industry experts.

Understand filter context

Understand filter context - Microsoft Excel Tutorial

From the course: Excel Business Intelligence: Power Pivot and DAX

Start my 1-month free trial Buy for my team

Understand filter context

“

- [Narrator] Alright, time to revisit this idea of filter context. Now I told you this was one of those top five most critical concepts in the course, so it's worth revisiting. We're gonna dive in quite a bit deeper now. So as a reminder, measures are always calculated based on filter context and simply put, filter context is the set of filters or coordinates that are determined by a Pivot Table's layout. So what fields you've got on filters, whether you have any slicers in there, if you're breaking down your data by row labels or by column labels, all of those things that determine a Pivot Table's layout or orientation impact the values that the measures are gonna show. And this is nothing new. This is just like how the value fields in a regular Pivot Table work. But what we need to understand about power pivot is that each measure cell within the pivot table calculates independently and it calculates based on its coordinates. So think of each cell in a pivot table as its own little…

Contents