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.
Remove filter context with ALL - Microsoft Excel Tutorial
From the course: Excel Business Intelligence: Power Pivot and DAX
Remove filter context with ALL
- [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…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Contents
-
-
-
-
-
(Locked)
Introduction to DAX functions27s
-
DAX formula syntax and operators4m 5s
-
(Locked)
Common DAX function categories3m 54s
-
(Locked)
Basic math and stats functions12m 45s
-
(Locked)
COUNT, COUNTA, DISTINCTCOUNT, and COUNTROWS10m 35s
-
(Locked)
Logical Functions (IF, AND, and OR)16m 49s
-
(Locked)
Switch and Switch (TRUE)10m 33s
-
(Locked)
Text functions10m 53s
-
(Locked)
The CALCULATE function14m 39s
-
(Locked)
Add filter context with FILTER: Part 19m 20s
-
(Locked)
Add filter context with FILTER: Part 214m 23s
-
(Locked)
Remove filter context with ALL9m 6s
-
Join data with RELATED3m 39s
-
(Locked)
Iterator ("X") functions: SUMX12m 20s
-
(Locked)
Iterator ("X") functions: RANKX5m 33s
-
(Locked)
Basic date and time functions4m 58s
-
(Locked)
Time intelligence formulas17m 2s
-
(Locked)
Speed and performance considerations3m 2s
-
(Locked)
DAX best practices2m 3s
-
(Locked)
-