Menu
CoddyTech
Start learning

ALL Removes Filters

Part of the DAX with CALCULATE section of Coddy's Power BI journey. Lesson 6 of 24.

ALL(Table) inside CALCULATE removes every filter on that table.

All Categories = CALCULATE([Revenue], ALL(Products))

Each category bar loses its filter, so every bar shows the total of all categories.

Filters on other tables, like a year slicer, stay.

challenge icon

Challenge

Write All Categories: Revenue with every filter on Products removed. It is checked for each category, so every row shows the same total.

bugsy Main icon

Start this challenge with Coddy's AI tutor

What is Bugsy?

All lessons in DAX with CALCULATE

1Changing the Filters

Meet CALCULATEA Filter Replaces a FilterSeveral Filters at OnceKeeping FiltersRecap - Member Drink Sales

4DAX You Can Read

Variables with VARChoosing with SWITCHSWITCH(TRUE()) for RangesOne Value or ManyRows or the TotalChecking Copilot's DAXRecap - Sales by Price Band

2Removing Filters

ALL Removes FiltersPercent of TotalRemoving One FilterKeep One Filter: ALLEXCEPTShare of What Is ShownRecap - Store Share in 2025

3Row by Row in a Measure

SUMX Works Row by RowAVERAGEX and MAXXFILTER Picks RowsMeasures Inside IteratorsRanking with RANKXRecap - Profit Without Columns