find non matching rows in two tables with many to one relationship

[Anonymous]

i have two tables below Table1 and Table 2 with 1:many relationship on Table 1[Column1] and Table 2[Column1].

I want to find rows that are in Table 1  but not in Table 2  and vice versa based on join on [Column1].

If drag all columns from both tables and select 'show items with no data' it gives me all records but i want to filter them based on my desired criteria. I want to do this without using Merge. 

So i want below result

rows in Table 1 but not in Table 2

Column1   Column2

5                  dff

 rows in Table 2 but not in Table 1

Column1    Column2

7                  ds

7                  ffd

8                  fdf

8                  ffd

Table 1

Column1       Column2

1	abc
2	dff
3	ddd
4	sss
5	dff
6	erf

Table 2

Column1        Column2

1	gjj
1	fgf
2	df
2	fg
3	ss
3	ffg
4	sdds
4	gfgf
6	ds
6	dd
7	ds
7	ffd
8	fdf
8	ffd

[Zubair_Muhammad · Accepted solution]

Hi @Anonymous 

Try these Measures as Visual Filters for tables 1 and 2 respectively
See attached file as well

Measure =
IF (
    NOT ( CONTAINS ( Table2, Table2[Column1], SELECTEDVALUE ( Table1[Column1] ) ) ),
    1
)

Measure 2 =
IF (
    NOT ( CONTAINS ( Table1, Table1[Column1], SELECTEDVALUE ( Table2[Column1] ) ) ),
    1
)