GROUPCROSSAPPLY 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 representing the column name to use for the subsequent expression specified. |
|
Expression By Expression |
Repeatable |
Any DAX expression that returns a single value (not a table). |
Return values
A table which includes combinations of values from the supplied columns based on the grouping specified. Only rows for which at least one of the supplied expressions return a non-blank value are included in the table returned. If all expressions evaluate to BLANK/NULL for a row, that row is not included in the table returned.
Remarks
This function is mainly used internally by Power BI to query remote models in composite models.
GROUPCROSSAPPLY is similar to SUMMARIZECOLUMNS function, but it does not apply implicit autoexist. All FilterTable parameters are cross-join. FILTERCLUSTER function can be used to perform natural joins of filter tables or group by columns if needed.
You can modify filtering behavior of FilterTable by using the following functions: ALLSELECTEDAPPLY, ALLSELECTEDREMOVE, ALWAYSAPPLY, KEEPFILTERS, SHADOWCLUSTER, NONFILTER.
Related articles
Learn more about GROUPCROSSAPPLY 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/groupcrossapply-function-dax