IGNORE DAX Function (Table manipulation)

Tags a measure expression specified in the call to SUMMARIZECOLUMNS function to be ignored when determining the non-blank rows.

Syntax

IGNORE ( <Measure_Expression> )

Parameter	Attributes	Description
Measure_Expression		The Expression which needs to be ignored for the purposes of determining non-blank rows.

Return values

This function does not return a value.

Remarks

The IGNORE() syntax can be used to modify the behavior of the SUMMARIZECOLUMNS function by omitting specific expressions from the BLANK/NULL evaluation. Rows for which all expressions not using IGNORE return BLANK/NULL will be excluded independent of whether the expressions which do use IGNORE evaluate to BLANK/NULL or not.

» 2 related articles
» 1 related function

Examples

--  IGNORE tags a measure in SUMMARIZECOLUMNS to be ignored when
--  determining the non-blank rows.
EVALUATE
SUMMARIZECOLUMNS (
    'Date'[Calendar Year],
    "Amount", [Sales Amount]
)

EVALUATE
SUMMARIZECOLUMNS (
    'Date'[Calendar Year],
    "Amount", IGNORE ( [Sales Amount] )
)

Calendar Year	Amount
2007-01-01	11,309,946.12
2008-01-01	9,927,582.99
2009-01-01	9,353,814.87

Calendar Year	Amount
2005-01-01	(Blank)
2006-01-01	(Blank)
2007-01-01	11,309,946.12
2008-01-01	9,927,582.99
2009-01-01	9,353,814.87
2010-01-01	(Blank)
2011-01-01	(Blank)

Learn more about IGNORE in the following articles:

Introducing SUMMARIZECOLUMNS
This article explains how to use SUMMARIZECOLUMNS, which is a replacement of SUMMARIZE and does not require the use of ADDCOLUMNS to obtain good performance. » Read more
The importance of star schemas in Power BI
Creating a star schema in Power BI is the best practice to improve performance and more importantly, to ensure accurate results! This article shows why a star schema can fix some of the issues in your report. » Read more