Locked lesson.
About this lesson
Creating measures for our sample model using ALL()
Exercise files
Download this lesson’s related exercise files.
4-08 Begin.pbix413.3 KB 4-08 Complete.pbix
413.3 KB
Quick reference
The ALL() function - Application
Creating measures for our sample model using ALL()
Instructions
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 the use of slicers
Sorry, we don’t have a transcript for this lesson yet.
Lesson notes are only available for subscribers.