Power Bi formula - exclude rows when value equals filter

Hi Jaypearce ,

I’ve completed your requirements using sample data and achieved the expected results. I’ve included snapshots of the output for your review.

When you have a chance, please let me know if this meets your expectations or if you have any suggestions for improvements.

FYI:

For Disconnected Table:

Fruit Slicer = DISTINCT(UNION(
    SELECTCOLUMNS(FruitData, "Fruit", FruitData[Fruit]),
    SELECTCOLUMNS(FruitData, "Fruit", FruitData[Fruit V2])
))

Used Measure:

Show Row = 
VAR SelectedFruits = VALUES('Fruit Slicer'[Fruit])
VAR SelectedCount = COUNTROWS(SelectedFruits)

VAR FruitInFilter = MAX(FruitData[Fruit]) IN SelectedFruits
VAR FruitV2InFilter = MAX(FruitData[Fruit V2]) IN SelectedFruits

RETURN
    SWITCH(
        TRUE(),
        SelectedCount = 0, 1,                        
        SelectedCount = 1, 0,                      
        FruitInFilter && FruitV2InFilter, 1,        
        0                                         )