In this video, the instructor explains how to use the ALL function to remove filter context within a PivotTable, and demonstrates how it is commonly used for "% of whole" calculations defined by DAX measures.
- [Instructor] Alright next up, time to talk about…the all function.…Now basically the all function can do two things.…It can return all the rows in a table…or all the values in a column, ignoring any filters…that have been applied.…So it works in kind of an opposite way to…the filter function, where the filter function adds…filter context; the all function removes it.…So syntax wise, pretty straightforward,…there's only one required argument…which is the table or column reference that you want…to clear the filters on.…
And you've also got an optional list of columns as well.…Couple things to note here, if your first argument…or parameter is a table then you're done,…that's the whole function,…just all, table reference, close parenthesis.…But if you specify column then you can specify…an additional list of columns as well provided that…A, they're fully qualified so they include the table name…and B, they all come from the same table.…So that allows you to do things like clear the filters…on columns A and B, but keep the filters on any others.…
- 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.