Filter table by table

Question

Hi,&nbsp;I am looking for soultion for this case.&nbsp;Assume I have two tables like this :Table1&nbsp;&nbsp;&nbsp;Table2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;IdName&nbsp;&nbsp;IdValue1Adam&nbsp;&nbsp;5402John&nbsp;&nbsp;6453Peter&nbsp;&nbsp;3554Megan&nbsp;&nbsp;442&nbsp;&nbsp;What I would like to get is table table one to be filtered out with ID values from table2 . ( In sql I would use "ID is not in" )&nbsp;So my result will be :&nbsp;&nbsp;IdName1Adam2John&nbsp;So values with IDs 3 and 4 are filtered out becasue they exist in column Id of table2&nbsp;

alb · Accepted Answer

Hi Marcin&nbsp;
You can create a new calculated table:
NewTable =
FILTER ( Table1, NOT Table1[Id] IN DISTINCT ( Table2[Id] ) )

Forum Discussion

Filter table by table

1 Reply

Related content

Filtered table

Can I filter the 1st fact table which then filters a 2nd fact table?

Matrix table

Filtering Table report

Lakehouse Table Generate Create Table

Table1		Table2

Id	Name	Id	Value
1	Adam	5	40
2	John	6	45
3	Peter	3	55
4	Megan	4	42

Id	Name
1	Adam
2	John