ALWAYSAPPLY 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 ALWAYSAPPLY within the context GROUPCROSSAPPLY and GROUPCROSSAPPLYTABLE functions, to override the standard behavior of those functions.
By default, a value filter does not affect measure if it doesn’t change filter context. This behavior can be controlled by ALWAYSAPPLY function so that an empty table can still affect measure even if it doesn’t change filter context.
Examples
-- Illustrative syntax only (internal Power BI / composite model pattern).
-- ALWAYSAPPLY makes the filter table affect the measures
-- even when it does not change the filter context, for example an empty table.
-- Not evaluated on dax.do: GROUPCROSSAPPLY targets remote/composite query shapes.
EVALUATE
GROUPCROSSAPPLY (
'Product'[Color],
ALWAYSAPPLY ( FILTER ( VALUES ( 'Product'[Color] ), FALSE ) ),
"Sales", [Sales Amount]
)
Related functions
Other related functions are:
Last update: Oct 19, 2026 » Contribute » Show contributors
Contributors: Alberto Ferrari, Marco Russo
Microsoft documentation: https://learn.microsoft.com/en-us/dax/alwaysapply-function-dax