IGNORE

Applies to: Calculated column Calculated table Measure Visual calculation

Modifies 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. This function can only be used within a SUMMARIZECOLUMNS expression.

Syntax

IGNORE(<expression>)

With SUMMARIZECOLUMNS,

SUMMARIZECOLUMNS(<groupBy_columnName>[, < groupBy_columnName >]…, [<filterTable>]…[, <name>, IGNORE(…)]…)

Parameters

Term	Definition
expression	Any DAX expression that returns a single value (not a table).

Return value

The function does not return a value.

Remarks

IGNORE can only be used as an expression argument to SUMMARIZECOLUMNS.

Example

See SUMMARIZECOLUMNS.