NONFILTER DAX Function (Filter)
Modifies how filters are applied while evaluating a GROUPCROSSAPPLY or GROUPCROSSAPPLYTABLE function.
Syntax
| Parameter | Attributes | Description |
|---|---|---|
| TableExpression |
Any table expression. |
Return values
Remarks
This function is mainly used internally by Power BI to query remote models in composite models.
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 functions
Other related functions are:
Last update: Dec 28, 2025 » Contribute » Show contributors
Contributors: Alberto Ferrari, Marco Russo
Microsoft documentation: https://learn.microsoft.com/en-us/dax/nonfilter-function-dax