This lecture introduces the concept of filter context, which is the set of filters passed by the PivotTable layout. Understanding filter context is critical to understanding how measures are calculated.
- [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 island.…It doesn't know the value in the cell…
- Power Pivots versus normal pivots
- Creating calculated columns and measures
- Power Pivot and DAX best practices
- Math, stats, and COUNT functions
- CALCULATE, FILTER, and ALL functions
- Joining data with RELATED
- Using iterator functions (SUMX and RANKX)
- Time intelligence formulas
Skill Level Intermediate
1. Getting Started
Set expectations1m 46s
2. Power Pivot and DAX 101
3. Common DAX Functions
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.