In this video, the instructor demonstrates how to add a FILTER function within CALCULATE to create new filter context in DAX.
- [Instructor] Next up we've got the filter function.…Now, by definition filter is pretty straight forward.…It returns a table that represents…a subset of another table.…So, in other words, it takes an input table,…filters it down, and spits out that filtered version.…And syntax wise, pretty straightforward as well.…You got your table argument,…which is just pointing to the table that we'd like…to filter: Store_Lookup, Product_Lookup both valid.…Then you've got this filter expression,…which is a Boolean or True/False filter expression.…
But there're a couple things to note here.…First is that this filter expression is evaluated…for every single row of the table.…And this is not how a calculate filter works.…So, a filter function is also an iterator.…And what that means is that it iterates row by row by row,…through an entire table,…checking whether the filter expression…is true or false for each of those rows.…And the other thing to note is that while a calculate filter…is limited to just column reference, operator, fixed value,…
- 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.