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.
In todays video I will show you how to use the DAX function IGNORE:
Download example files:
Download the pbix here.
IGNORE can be used as an expression argument to SUMMARIZECOLUMNS.