About this lesson
In this module we look at practical examples of using the ALL() function to modify and override the filter context, resulting in measures that only change when we want them to.
Download this lesson’s exercise file. You can download the source data files from the top of your Lessons page.The ALL() function - Application - Completed.pbix
The ALL() Function - Application
Creating measures for our sample model using ALL().
When to use
You want to practice using the ALL() function.
Create a multi-row card and add the Sales $ measure
Create the following measures and add them to the multi-row card:
Remove filters from an entire table
- Sales $ - All Time = CALCULATE([Sales $],all('Calendar'))
- Sales $ - All Locations = CALCULATE([Sales $],All(Locations))
Remove filters from a specific column on a table
- Sales $ - All Years = CALCULATE([Sales $],ALL('Calendar'[Year]))
Hints & tips
- Removing filters from a column is typically used to remove successive filters caused by use of slicers
Lesson notes are only available for subscribers.