FILTERCLUSTER DAX Function (Filter)
Returns a correlated join 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. Each GroupBy_ColumnName column is cross-joined (different tables) or auto-existed (same table) with the subsequent specified columns. |
| FilterTable | Repeatable |
A table expression participating in the join. |
| Separator |
A string literal which serves no purpose other than separating FilterTable parameter with TableScan parameter. |
|
| TableScan | Repeatable |
A table scan that joins with FilterTable parameters, applying autoexist semantics, and returns columns specified in GroupBy_ColumnName. |
Return values
A table which includes combinations of values from the supplied columns based on the grouping specified. The column only includes column specified by GroupBy_ColumnName parameter.
Remarks
This function is mainly used internally by Power BI to query remote models in composite models.
FILTERCLUSTER function can only be used inside GROUPCROSSAPPLY and GROUPCROSSAPPLYTABLE functions.
FILTERCLUSTER is semantically equivalent to a natural join across all FilterTable and TableScan parameters, and then group by columns specified by GroupBy_ColumnName parameters. Group by columns must come from TableScan parameters.
TableScan parameters are evaluated in the context of FilterTable.
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/filtercluster-function-dax