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.
The Expression which needs to be ignored for the purposes of determining non-blank rows.
This function does not return a value.
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
-- 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] ) )
Learn more about IGNORE in the following articles:
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
Other related functions are:
Last update: Jun 6, 2023 » Contribute » Show contributors
Contributors: Alberto Ferrari, Marco Russo
Microsoft documentation: https://docs.microsoft.com/en-us/dax/summarizecolumns-function-dax