CROSSFILTER

CROSSFILTER Specifies the cross-filtering direction to be used in a calculation for a relationship that exists between two columns.


Syntax

CROSSFILTER(columnName1, columnName2, direction)

Parameters

ColumnName1 – The name of an existing column, using standard DAX syntax and fully qualified, that usually represents the many side of the relationship to be used; if the arguments are given in reverse order the function will swap them before using them. This argument cannot be an expression.

ColumnName2 – The name of an existing column, using standard DAX syntax and fully qualified, that usually represents the one side or lookup side of the relationship to be used; if the arguments are given in reverse order the function will swap them before using them. This argument cannot be an expression.

Direction – The cross-filter direction to be used. Must be one of the following:
none

No cross-filtering occurs along this relationship

one – Filters on the one or lookup side of the side of the relationship filter the many side.

both – Filters on either side filter the other

none – No cross-filtering occurs along this relationship

Return Value

The function returns no value; the function only sets the cross-filtering direction for the indicated relationship, for the duration of the query.


Reference Data

https://docs.microsoft.com/en-us/dax/dax-function-reference

DAX Functions / Filter Functions / CROSSFILTER