IGNORE
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.
Feedback
https://aka.ms/ContentUserFeedback.
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see:Submit and view feedback for