🔗 Relationship Filter

FILTER PRODUCT TABLE:
Product A
All Products
Product (Lookup)
Relationship Flow
Sales (Fact)
Ready...

💻 DAX Formula

-- Check: Is 'Sales' filtered DIRECTLY?
MEASURE Direct_Check =
ISFILTERED( Sales[ProductID] )
-- Returns FALSE because we sliced the Product table, not Sales.

-- Check: Is 'Sales' filtered INDIRECTLY?
MEASURE Cross_Check =
ISCROSSFILTERED( Sales[ProductID] )
-- Returns TRUE because the filter flows Product -> Sales.
Return Value:
-