When should I use IGNORE instead of REMOVEFILTERS?

Use IGNORE when you want a measure to be excluded from a totals or visual-level calculation but kept in the per-row context — for example, hiding a metric from a grand-total row while leaving it in the underlying detail rows. REMOVEFILTERS strips filter context outright; IGNORE specifically suppresses a measure inside SUMMARIZECOLUMNS.

Does IGNORE work in plain CALCULATE?

No — IGNORE is designed to work inside SUMMARIZECOLUMNS as a wrapper around a measure expression. Putting IGNORE inside a regular CALCULATE doesn't have the same effect; CALCULATE doesn't recognise it as a filter-suppression marker.

Can I IGNORE multiple measures in a single SUMMARIZECOLUMNS?

Yes. Each measure expression you want to suppress at the totals/blank-row level can be wrapped in its own IGNORE inside the same SUMMARIZECOLUMNS call. Each IGNORE applies independently to its own argument.

Will IGNORE hide rows or just suppress a value?

It suppresses the value, not the row. A row with all IGNORE'd measures may still appear in the output if other (non-ignored) measures produce a value for it. To filter out rows entirely you need a separate WHERE-style filter or a filter argument to SUMMARIZECOLUMNS.

Is IGNORE supported in older Power BI versions?

IGNORE was introduced relatively recently in the DAX language; older Analysis Services Tabular models (pre-2019) and some legacy Power BI Desktop versions don't support it. Check the model compatibility level before relying on it in shared semantic models.

DAX

Dax Function: IGNORE

Q: What does the IGNORE function do in Power BI?

The IGNORE function removes specific filters from the current filter context, allowing calculations to proceed as if those filters were not applied.

Q: How is IGNORE different from REMOVEFILTERS?

While both remove filters, IGNORE specifically targets columns within a calculation's context, whereas REMOVEFILTERS can remove all filters globally.

Q: Can IGNORE handle multiple columns at once?

Yes, you can specify multiple columns in the IGNORE function to remove filters from all of them.

Reviewed by Neetu Singla — Founder, Lets Viz Technologies — AI & Data Consultant. Last reviewed April 27, 2026.

Category: Table Manipulation Functions

The IGNORE function in Power BI DAX is used in the context of calculations to temporarily remove specific filters from being applied. This function plays a significant role in managing the filter context when defining calculated columns or measures, allowing for more control over calculations.

Purpose

Filter Context Management: Removes the impact of specified filters on calculations.
Custom Aggregations: Facilitates the creation of aggregations that ignore certain dimensions or criteria.
Advanced Analysis: Useful in scenarios where calculations need to disregard specific filters selectively.

Type of Calculations

Removes specific filter criteria from the current filter context during evaluations.
Enables comparative or cumulative calculations where certain filters must be excluded.

Practical Use Cases

Cumulative Totals: Calculate a running total that ignores filters on time periods.
Global Metrics: Create measures that represent global totals, irrespective of slicers or other filters.
Benchmarking: Compare filtered data to an unfiltered baseline.


IGNORE ( <columnname>, ... )</columnname>

Parameter	Type	Description
columnName	Column	One or more columns whose filters should be ignored in the calculation.

How Does IGNORE Dax Works

Filter Removal: IGNORE removes the filters applied on the specified columns, effectively treating them as unfiltered in the context of the calculation.
Modified Context Evaluation: The calculation then proceeds in the modified context, enabling results that reflect an adjusted view of the data.

Key Points

Temporary Effect: IGNORE only applies to the context of the calculation where it is used.
Selective Exclusion: Allows precise control over which filters are ignored, enhancing calculation flexibility.

What Does It Return?

Modified Filter Context: The function modifies the filter context for the current calculation by excluding the specified filters. The result is an adjusted calculation as per the new context.

When Should We Use It?

Global Metrics: To calculate metrics like total revenue ignoring region or product filters.
Comparative Metrics: Comparing filtered data (e.g., sales in a specific region) against unfiltered data (e.g., global sales).
Custom Visualizations: Creating visualizations that require specific filters to be ignored selectively.

Examples

Basic Usage :

Ignore a filter on a specific column:


CALCULATE ( SUM ( Sales[Amount] ), IGNORE ( Sales[Region] ) )

Result: Calculates the total sales amount across all regions, ignoring any filters applied to the Region column.

Column Usage

Compare filtered and unfiltered sales:


Filtered vs Unfiltered Sales =
SUM ( Sales[Amount] ) / CALCULATE ( SUM ( Sales[Amount] ), IGNORE ( Sales[Region] ) )

Result: Calculates the ratio of filtered sales to unfiltered sales by ignoring the Region filter.

Advanced Usage

Cumulative totals that ignore date filters:


Cumulative Sales =
CALCULATE (
SUM ( Sales[Amount] ),
IGNORE ( Sales[Date] )
)

Result: Calculates cumulative sales, disregarding any filters applied to the Date column.

Tips and Tricks

Use IGNORE when you need explicit control over which filters to exclude.
Combine with CALCULATE to apply custom filter logic alongside ignored filters.
Overuse: Excessive use of IGNORE can lead to performance degradation.
Unintended Context Changes: Ensure you understand the implications of removing filters on the overall calculation context.

Performance Impact of IGNORE DAX Function:

Optimize Scope: Only ignore the filters you absolutely need to exclude to minimize unnecessary context changes.
Combine Carefully: Use IGNORE in combination with other DAX functions like CALCULATE for fine-tuned calculations.

Related Functions You Might Need

Function	Description
`REMOVEFILTERS`	Removes all filters from the specified columns or tables.
`CALCULATE`	Modifies the filter context for a calculation.
`ALL`	Removes all filters from a table or column, similar to IGNORE.

Want to Learn More?
For more information, check out the official Microsoft documentation for IGNORE You can also experiment with this function in your Power BI reports to explore its capabilities.

Unlock the full capabilities of Power BI and elevate your data insights with our specialized consulting services. Whether you need guidance on advanced DAX functions like those highlighted here, support in designing interactive dashboards, or expertise in optimizing data models for enhanced performance, our experienced Power BI consultants are equipped to deliver customized solutions for your business. Explore our Power BI Consulting Services page to discover how we can help your organization make smarter, data-driven decisions.

1. What does the IGNORE function do in Power BI?

The IGNORE function removes specific filters from the current filter context, allowing calculations to proceed as if those filters were not applied.

2. How is IGNORE different from REMOVEFILTERS?

While both remove filters, IGNORE specifically targets columns within a calculation’s context, whereas REMOVEFILTERS can remove all filters globally.

3. Can IGNORE handle multiple columns at once?

Yes, you can specify multiple columns in the IGNORE function to remove filters from all of them.

4. What are common use cases for IGNORE?

Typical use cases include creating global metrics, calculating cumulative totals, or benchmarking filtered data against unfiltered results.

5. Is IGNORE resource-intensive for large datasets?

It can be if used excessively or on unfiltered large datasets. Apply it judiciously to avoid performance issues.

Need a Power BI consultant for your team?

We've built Power BI dashboards and data automation for 100+ clients across finance, sales, operations, and executive reporting. Fixed-fee MVPs, first production dashboard in 3–4 weeks.

Finance BI — P&L, balance sheet, budget vs actual, cash forecast
Sales BI — CRM data cleaned, pipeline and forecast dashboards leadership trusts
Operations BI — real-time KPIs with validation and alerting built in
Embedded Power BI inside SaaS products with row-level security

See the Fortivis case study for a real example: an Athens-based financial advisory firm that replaced their multi-day manual reporting cycle with a validated Power BI pipeline.

Book a free Power BI strategy call

IGNORE vs REMOVEFILTERS vs ALL

	IGNORE	REMOVEFILTERS	ALL
Purpose	Suppress a measure inside SUMMARIZECOLUMNS	Drop filter context on table/column	Drop filters or return all rows
Used inside	SUMMARIZECOLUMNS only	CALCULATE / CALCULATETABLE	CALCULATE / table iterator
Affects which rows render	Suppresses value, row may stay	Removes filter, all rows return	Removes filter, all rows return
Most-common pattern	Hide measure from totals/blank row	Compute % of grand total	Older % of total / ratio measures
Read at a glance	High (intent is clear)	High	Medium — overloaded function
Modern preferenceREMOVEFILTERS is functionally equivalent to ALL in CALCULATE context but reads clearer.	✓ for total-row suppression	✓ for filter removal	Legacy — prefer REMOVEFILTERS

Dax Function: GROUPBY

Dax Function: INTERSECT

Past the Tutorial

Need Power BI help in a real engagement?

Our team writes DAX like this every day for SaaS finance and ops teams. Refresh monitoring, change requests with a 2-business-day SLA, and a named analyst on retainer — or scoped hourly help if you just need a fix.

Explore Managed Power BI See Pricing Guide

Named analyst2-day SLAFrom $5K/mo

Power BI analyst working with finance dashboards