Subscriber only lesson.
Sign up to this course to view this lesson.
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 source data files for the course from the resources section 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.