Conditional Formatting on a text field based on Slicer selections from a separate dataset

Hi , Anonymous 

Try measure as below :

Measure1 =
VAR _cotc =
    CALCULATETABLE (
        VALUES ( 'Brands&COTC'[COTC] ),
        FILTER (
            ALL ( 'Brands&COTC' ),
            'Brands&COTC'[COTC] IN FILTERS ( Slicer[slicer_COTC] )
        )
    )
VAR _sku =
    CALCULATETABLE (
        VALUES ( 'Brands&COTC'[SKU Desc] ),
        FILTER ( ALL ( 'Brands&COTC' ), 'Brands&COTC'[COTC] IN _cotc )
    )
VAR _skureflect =
    CALCULATETABLE (
        VALUES ( 'Brand&SKU'[Description] ),
        FILTER ( ALL ( 'Brand&SKU' ), 'Brand&SKU'[SKU Desc] IN _sku )
    )
VAR _description =
    CALCULATETABLE (
        VALUES ( 'Data Table'[Customer ID] ),
        FILTER ( ALL ( 'Data Table' ), 'Data Table'[Description] IN _skureflect )
    )
RETURN
    IF ( MAX ( 'Data Table'[Customer ID] ) IN _description, 1, 0 )

Then apply it to background conditional formatting.

pbix attached

Best Regards,
Community Support Team _ Eason
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.