ALL function for removing filters in Power BI - Step-by-Step Guide

Introduction

The ALL function in Power BI helps you ignore filters on a table or column. This lets you see total values without any filter affecting the result. It is useful when you want to compare filtered data to the overall total.

When you want to show total sales for all regions even if a region filter is applied.

When creating a percentage of total measure that ignores slicer selections.

When you want to reset filters on a specific column inside a measure calculation.

When comparing filtered results to the grand total in a report.

When you want to clear filters on a table to calculate overall averages.

Steps

Step 1: Open

- Power BI Desktop

Power BI Desktop opens with your report and data model loaded

Step 2: Click

- Modeling tab

Modeling ribbon options appear

Step 3: Click

- New measure button

A formula bar appears at the top for writing DAX

Step 4: Type

- Formula bar

The measure formula is entered

💡 Example formula: Total Sales All = CALCULATE(SUM(Sales[Amount]), ALL(Sales))

Step 5: Press

- Enter key

The new measure is created and appears in the Fields pane

Step 6: Add

- Report canvas

The measure visualizes total sales ignoring any filters on the Sales table

Before vs After

Before

A sales chart filtered to show only the East region with total sales of 100,000

After

The same chart shows total sales of 500,000 for all regions ignoring the East filter

Settings Reference

ALL function

📍 DAX formula bar

Removes filters from the specified table or column

Default: No default, used inside CALCULATE or other functions

CALCULATE function

📍 DAX formula bar

Changes filter context for the expression, often combined with ALL

Default: No default, used to modify filter context

Common Mistakes

Using ALL without CALCULATE in a measure

ALL alone does not change filter context unless inside CALCULATE

Use ALL inside CALCULATE to remove filters properly, e.g. CALCULATE(SUM(Sales[Amount]), ALL(Sales))

Applying ALL to a column when you want to remove filters on the whole table

Removing filters on one column may not clear all filters affecting the table

Use ALL on the entire table to remove all filters, e.g. ALL(Sales)

Summary

The ALL function removes filters from a table or column in DAX calculations.

Use ALL inside CALCULATE to change filter context and see totals ignoring slicers or filters.

Remember to choose ALL on the right table or column depending on which filters to remove.