Filtering through multiple columns using one filter

Hey ouss102 ,

that is possible.

Create a new table with DAX that you are using as a slicer:

Buyer = 
FILTER(
    DISTINCT(
        UNION(
            VALUES( myTable[Buyer.1] ),
            VALUES( myTable[Buyer.2] ),
            VALUES( myTable[Buyer.3] )
        )
    ),
    myTable[Buyer.1]
        <> BLANK()
)

As I said, this you can use to slice the names later.

Then you create a measure that checks for every row if the name appears in one of the 3 columns:

ShowRow =
VAR vSelected = ALLSELECTED( Buyer[Buyer] )
VAR vAvailableNamesTable =
    FILTER(
        DISTINCT(
            UNION(
                VALUES( myTable[Buyer.1] ),
                VALUES( myTable[Buyer.2] ),
                VALUES( myTable[Buyer.3] )
            )
        ),
        myTable[Buyer.1] <> BLANK()
    )
VAR vIntersect = INTERSECT( vSelected, vAvailableNamesTable )
RETURN
    COUNTROWS( vIntersect )

Use this measure as a filter for the visual for the table you want to show and filter it to ShowRow = 1:

Then the result is doing exactly what you want:

Please check my demo file:

https://www.swisstransfer.com/d/0dac3f4b-4189-4e0b-b1e9-edaefdbe5c09