ISCROSSFILTERED DAX Function (Information)
Returns true when the specified table or column is crossfiltered.
Syntax
| Parameter | Attributes | Description |
|---|---|---|
| TableNameOrColumnName |
The column or table to check the filter info. |
Return values
TRUE when any column of the table specified or of a related table is being filtered. Otherwise returns FALSE.
Remarks
A column or table is said to be cross-filtered when a filter is applied to any column of the same table or in a related table.
A column is said to be filtered directly when the filter or filters apply over the column.
» 2 related functions
Examples
-- ISFILTERED checks whether a column has a direct filter
-- ISCROSSFILTERED checks whether a column has either a direct
-- or an indirect filter (which is a filter propagated from a related column)
--
-- In this example we place the filter on the 1 side of a 1:* relationship
EVALUATE
CALCULATETABLE (
{
( "ISFILTERED Product[Color]", ISFILTERED ( Product[Color] ) ),
( "ISFILTERED Sales[Quantity]", ISFILTERED ( Sales[Quantity] ) ),
( "ISCROSSFILTERED Product[Category]", ISCROSSFILTERED ( Product[Category] ) ),
( "ISCROSSFILTERED Product", ISCROSSFILTERED ( Product ) ),
( "ISCROSSFILTERED Sales", ISCROSSFILTERED ( Sales ) )
},
'Product'[Color] = "Red"
)
| Value1 | Value2 |
|---|---|
| ISFILTERED Product[Color] | true |
| ISFILTERED Sales[Quantity] | false |
| ISCROSSFILTERED Product[Category] | true |
| ISCROSSFILTERED Product | true |
| ISCROSSFILTERED Sales | true |
-- ISFILTERED checks whether a column has a direct filter
-- ISCROSSFILTERED checks whether a column has either a direct
-- or an indirect filter (which is a filter propagated from a related column)
--
-- In this example we place the filter on the many side of a 1:* relationship
EVALUATE
CALCULATETABLE (
{
( "ISFILTERED Sales[Quantity]", ISFILTERED ( Sales[Quantity] ) ),
( "ISFILTERED Product[Color]", ISFILTERED ( Product[Color] ) ),
( "ISCROSSFILTERED Sales", ISCROSSFILTERED ( Sales ) ),
( "ISCROSSFILTERED Product[Category]", ISCROSSFILTERED ( Product[Category] ) ),
( "ISCROSSFILTERED Product", ISCROSSFILTERED ( Product ) )
},
Sales[Quantity] = 1
)
| Value1 | Value2 |
|---|---|
| ISFILTERED Sales[Quantity] | true |
| ISFILTERED Product[Color] | false |
| ISCROSSFILTERED Sales | true |
| ISCROSSFILTERED Product[Category] | false |
| ISCROSSFILTERED Product | false |
-- ISFILTERED checks whether a column has a direct filter
-- ISCROSSFILTERED checks whether a column has either a direct
-- or an indirect filter (which is a filter propagated from a related column)
--
-- In this example we place the filter on the many side of a 1:* relationship
-- enabling bidirectional cross-filter
EVALUATE
CALCULATETABLE (
{
( "ISFILTERED Sales[Quantity]", ISFILTERED ( Sales[Quantity] ) ),
( "ISFILTERED Product[Color]", ISFILTERED ( Product[Color] ) ),
( "ISCROSSFILTERED Sales", ISCROSSFILTERED ( Sales ) ),
( "ISCROSSFILTERED Product[Category]", ISCROSSFILTERED ( Product[Category] ) ),
( "ISCROSSFILTERED Product", ISCROSSFILTERED ( Product ) )
},
Sales[Quantity] = 1,
CROSSFILTER ( Sales[ProductKey], 'Product'[ProductKey], BOTH )
)
| Value1 | Value2 |
|---|---|
| ISFILTERED Sales[Quantity] | true |
| ISFILTERED Product[Color] | false |
| ISCROSSFILTERED Sales | true |
| ISCROSSFILTERED Product[Category] | true |
| ISCROSSFILTERED Product | true |
Related articles
Learn more about ISCROSSFILTERED in the following articles:
-
Clever Hierarchy Handling in DAX
Hierarchy handling in DAX is not very easy, due to the fact that hierarchies, unlike it was in MDX, are not first-class citizens in the DAX world. While hierarchies can be easily defined in the data model, there are no DAX functions that let you access, for example, the parent of the CurrentMember. Well, to tell the truth, there is no concept of CurrentMember in DAX either. » Read more
-
Implement Non Visual Totals with Power BI security roles
This article describes how to implement non-visual-totals with security roles in Power BI and Analysis Services Tabular, which by default show only visual totals of measures in the model. » Read more
-
Optimizing duplicated DAX expressions using variables
This article describes how to use variables to optimize the performance of DAX expressions containing multiple instances of the same measure or the same sub-expression. » Read more
-
Customizing default values for each user in Power BI reports
This article shows how to use calculation groups to define a default set of values for columns in your model. Different users can have different default values, and yet retain the full capability to select different values. » Read more
Related functions
Other related functions are:
Last update: Oct 27, 2024 » Contribute » Show contributors
Contributors: Alberto Ferrari, Marco Russo, Kenneth Barber
Microsoft documentation: https://docs.microsoft.com/en-us/dax/iscrossfiltered-function-dax