--  FILTER returns the filters directly applied to a column
EVALUATE
CALCULATETABLE (
    FILTERS ( 'Product'[Category] ),
    'Product'[Category] = "Audio"
)

EVALUATE
CALCULATETABLE (
    FILTERS ( 'Product'[Category] ),
    'Product'[Category] IN { "Audio", "Computers" }
)

--  Non-existing values are not considered as filters
--  The "Bananas" category does not exist in Product table
EVALUATE
CALCULATETABLE (
    FILTERS ( 'Product'[Category] ),
    'Product'[Category] IN { "Audio", "Bananas" }
)

--  Filter on one column does not affect other columns,
--  which are cross-filtered but not filtered.
--  Only "Cameras and camcorders" has products with Azure color.
EVALUATE
CALCULATETABLE (
    FILTERS ( 'Product'[Category] ),
    'Product'[Color] = "Azure"
)

EVALUATE
CALCULATETABLE (
    VALUES ( 'Product'[Category] ),
    'Product'[Color] = "Azure"
)

--  Table filter include columns used in FILTERS
EVALUATE
CALCULATETABLE (
    FILTERS ( 'Product'[Category] ),
    FILTER ( 'Product', 'Product'[Color] = "Azure" )
)

--  FILTERS returns its values even though there are no
--  rows satisfying the set of conditions.
--  The table returned by FILTERS has the correct lineage.
EVALUATE
CALCULATETABLE (
    ADDCOLUMNS (
        FILTERS ( 'Product'[Color] ),
        "#Prods", CALCULATE ( COUNTROWS ( 'Product' ) )
    ),
    'Product'[Color] IN { "White", "Azure" },
    'Product'[Brand] = "Litware"
)