Remove rows from a Join Table

Hi Anonymous - you can use FILTER on the output of SELECTCOLUMNS to remove rows prior to the UNION happening.

FILTER ( SELECTCOLUMNS (...), [Filter Condition] )

You could also potentially use FILTER inside SELECTCOLUMNS by first filtering the base table, then choosing the columns

SELECTCOLUMNS ( FILTER ( [Table], [Filter Condition] ), ... )

Hope this helps

David

FILTER( TableName, NOT(TableName[ID_FW] IN {"xx", "yy", "zz"} ) ) 

should work (obviously if the IDs are numbers, don't need the quotes).  If it isn't please share your error message or what behavior you are seeing.

Hope this helps,

David