Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
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