The ALL() function - Application

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