Conditional value in Filtering context

Hi sebouier ,

AnkitaaMishra Thanks for your reply!

And sebouier , please try this way:
First use this DAX to create a new table for slicer:

Slicer = VALUES('Table'[Cat])

Note: without any relationship!

Then use this DAX to create a measure:

Measure = 
VAR _Cat = VALUES(Slicer[Cat])
VAR _Name = MAX('Table'[Name])
RETURN
IF(
    CALCULATE(
        COUNTROWS(
            FILTER(
                'Table',
                'Table'[Name] = _Name && 'Table'[Cat] IN _Cat
            )
        ),
        ALLSELECTED('Table')
    ) > 0,
    1,
    0
)

Set it up as shown in the following figure:

Then use this DAX to create another measure:

Flag = 
IF(
    MAX('Table'[Cat]) IN VALUES(Slicer[Cat]),
    1,
    0
)

And put this measure into the table visual:

The final output is as below:

Best Regards,
Dino Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.