Syntax
IGNORE(<expression>)
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.
Video Tutorial
In todays video I will show you how to use the DAX function IGNORE:

Download example files:
Download the pbix here.
Remarks
IGNORE can be used as an expression argument to SUMMARIZECOLUMNS.
Was this helpful?
Leave a Reply