Dax Calculation Help

[laurmell]

Hi folks, I need help creating a dax calculation for people with rights for system a and rights in system b. I have a list of names and a list of rights that each person has. The problem is there are multiple rights for a and multiple rights for b. Please see the table below for Clarification. 

Name	Right Name
VB	aaa_121
SU	bbb_123
SU	aaa_123
MN	bbb_0
MN	aaa_0
MN	aaa_121
BC	aaa_121
GM	bbb_123
GM	aaa_123
MJ	bbb_5000
CM	bbb_123a
CM	aaa_123a
LJ	bbb_5000b
JMD	bbb_5000a
KC	aaa_123
BI	bbb_4000a
BI	bbb_4000b
BI	bbb_5000a
BI	bbb_5000b
BI	bbb_123
BI	aaa_123
WK	bbb_123
WK	aaa_123
DFN	bbb_5000e
VAP	bbb_5000b
GM	aaa_121
SM	bbb_123
BJF	bbb_5000
SR	aaa_121
SR	aaa_123

I need to check whether each person has the same rights in system a as system b. 

[amitchandak]

@laurmell , You need to have a name and the right table

example

new table

Dim1 =

Distinct(union(Summarize(Table1,Table1[Name],Table1[Right Name]),Summarize(Table2,Table2[Name],Table2[Right Name]) )

Create a combine column in all three table and use that in join

= [Name] & "-" & [Right Name]

Then create a measure like

only matched

Countx(filter( summarize(Dim, Dim[Name], Dim[Right Name], "_1", Count(Table1[Name]) , "_2", Count(Table1[Name]) ) , [_1] =[_2]), [Name])