GROUPCROSSAPPLYTABLE DAX Function (Filter)
Returns a summary table over a set of groups.
Syntax
| Parameter | Attributes | Description |
|---|---|---|
| GroupBy_ColumnName | Repeatable |
A fully qualified column reference (Table[Column]) to a base table for which the distinct values are included in the returned table. |
| FilterTable | Repeatable |
A table expression which is added to the filter context of all columns specified as GroupBy_ColumnName arguments. |
| Name | Repeatable |
A string literal which serves no purpose other than separating FilterTable parameter with TableExpression parameter. |
| TableExpression | Repeatable |
A table expression that is evaluated under filter context of filterTable parameters and returned as a part of the join in the return value |
Return values
A table which includes combinations of values from the supplied columns based on the grouping specified.
Remarks
This function is mainly used internally by Power BI to query remote models in composite models.
GROUPCROSSAPPLYTABLE is similar to GROUPCROSSJOIN function. All FilterTable parameters are cross-join. FILTERCLUSTER function can be used to perform natural joins of filter tables or group by columns if needed.
The table expression parameter is evaluated in the filter context containing all FilterTable parameters.
You can modify filtering behavior of FilterTable by using the following functions: ALLSELECTEDAPPLY, ALLSELECTEDREMOVE, ALWAYSAPPLY, KEEPFILTERS, SHADOWCLUSTER, NONFILTER.
Related articles
Learn more about GROUPCROSSAPPLYTABLE in the following articles:
-
Using ALLSELECTED in composite models
Using ALLSELECTED with no arguments in a remote model later used in a composite model might produce unexpected results. In this article we examine the topic and provide the reasons why ALLSELECTED requires special attention. » Read more
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/groupcrossapplytable-function-dax