NONFILTER

Applies to: Calculated column Calculated table Measure Visual calculation

Modifies how filters are applied while evaluating a GROUPCROSSAPPLY or GROUPCROSSAPPLYTABLE function.

Syntax

NONFILTER(<table expression>)

Parameters

Term	Definition
table expression	Any table expression.

Return value

A table of values.

Remarks

• You use NONFILTER within the context GROUPCROSSAPPLY and GROUPCROSSAPPLYTABLE functions, to override the standard behavior of those functions.

• A NONFILTER makes the table expression permanently hidden from the filter context even if its columns may have lineage. Those columns with lineage act as if they are extension columns.

Related content

• Filter functions
• GROUPCROSSAPPLY function
• GROUPCROSSAPPLYTABLE function