Count the matched value in two columns in two different tables

[Anonymous]

Hi,

I need help in counting the matching values in two different tables.

Table 1= Users

Column1	Column2	Phone
aaa	ttt	1234
aas	rrr	2345
abb	eee	3456
aaf	ffff	3456

Table 2= New Users

Phone

1234

2345

The end result should be 2 as there are only two matching values in the first table

[Samarth_18 · Accepted solution]

Hi @Anonymous ,

Create a measure like below:-

Measure =
COUNTROWS ( FILTER ( Users, Users[Phone] IN DISTINCT ( 'New Users'[Phone] ) ) )

Thanks,

Samarth

[mh2587]

try and see the detail of INTERSECT Function