List to Exclude

Hi Tais_28_95 ，

Not with your details data ,refer the below:
Expect table:

 

Main table:

 

 

First ,create new column on main table:

LOOKUP = IF(LOOKUPVALUE(ExceptTable[Excepttable],ExceptTable[Excepttable],Maintable[Bath])<>BLANK(),1,0)

Get:

Then create new table like the below:

Newtable =
FILTER (
    SELECTCOLUMNS (
        Maintable,
        "Bath", CALCULATE ( VALUES ( Maintable[Bath] ), Maintable[LOOKUP] = 0 ),
        "value2", CALCULATE ( VALUES ( Maintable[value2] ), Maintable[LOOKUP] = 0 )
    ),
    NOT ( ISBLANK ( [Bath] ) )
)

 

Outputresult:

Did I answer your question? Mark my post as a solution!

Best Regards

Lucien