Forum Discussion

shinney's avatar
shinney
Icon for Helper I rankHelper I
5 years ago
Solved

Remove rows which contains entries from another Table

Hello,   I'm trying to create a table visual that only contains approved Suppliers. There is another table with this approved list. However, because suppliers sometimes have slight variations in th...
Need Help
Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi shinney ,

You can create a calculated column as below, please find the details in the attachment.

Approved supplier = 
VAR _match =
    FIRSTNONBLANK (
        FILTER (
            VALUES ( 'B'[Approved Supplier List] ),
            SEARCH ( 'B'[Approved Supplier List], 'A'[Supplier], 1, 0 )
        ),
        1
    )
RETURN
    IF ( NOT(ISBLANK(_match)), 'A'[Supplier] )

In addition, you can refer the content in the following link to get it.

DAX – “CONTAINSX” Revisited: What WAS the Match?

Best Regards