Removing One Filter

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

REMOVEFILTERS(Table[Column]) removes the filter on one column; the rest stay.

Share in Country = DIVIDE([Revenue], CALCULATE([Revenue], REMOVEFILTERS(Products[Category])))

In a category by country matrix, each cell is a share of its country. Each column adds up to 100%.

REMOVEFILTERS(Table) works like ALL(Table) inside CALCULATE.

Challenge

What does each country buy? Write Share in Country: a category's Revenue as a share of its country's revenue. It is checked in a matrix of category by country.

Start this challenge with Coddy's AI tutor

What is Bugsy?

All lessons in DAX with CALCULATE

1Changing the Filters

Meet CALCULATE A Filter Replaces a Filter Several Filters at Once Keeping Filters Recap - Member Drink Sales

4DAX You Can Read

Variables with VAR Choosing with SWITCH SWITCH(TRUE()) for Ranges One Value or Many Rows or the Total Checking Copilot's DAX Recap - Sales by Price Band

2Removing Filters

ALL Removes Filters Percent of TotalRemoving One FilterKeep One Filter: ALLEXCEPT Share of What Is Shown Recap - Store Share in 2025

3Row by Row in a Measure

SUMX Works Row by Row AVERAGEX and MAXX FILTER Picks Rows Measures Inside Iterators Ranking with RANKX Recap - Profit Without Columns