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
| 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.
» 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) |
Related articles
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
Related functions
Other related functions are:
Last update: Apr 2, 2021 » Contribute » Show contributors
Contributors: Alberto Ferrari, Marco Russo
Microsoft documentation: https://docs.microsoft.com/en-us/dax/summarizecolumns-function-dax