Number of matching occurrences

[Pbiuserr]

Hello, 
Assuming I have two tables

Table1:

Name1

Name2

Name3

and Table2

Name1

Name2

Name1

Name2

Name4

Name5

Relationship one [Table1] many [Table2]

I would like to create a masure that will count, how many values from one side of the relationship, matches values from many side of the relationship (2) and another value how many does not (1)

[Ahmedx]

see attached
https://1drv.ms/u/s!AiUZ0Ws7G26Rhhp1nCcSyKJOrdiI?e=qf2oad

[FreemanZ · Accepted solution]

hi @Pbiuserr 

try to plot two card visuals with measures like:

count1 = 
COUNTROWS(
    INTERSECT(
        ALL(Table1[Name]),
        ALL(Table2[Name])
    )
)

count2 = 
COUNTROWS(
    EXCEPT(
        VALUES(Table2[Name]),
        VALUES(Table1[Name])
    )
)

it worked like:

[Pbiuserr]

Thank you! Can you advise what to do if second table has more columns than first one? Tried VALUES etc but does not work