Please assist with the following dax

[mighty]

Good day

I need assistance with this, I have two tables:
Table_1

Name	School Name
Jane	East
France	East
Crage	West
Dina	West
Joseph	North

Table_2

Name	School Name
Jane	North
France	East
Crage	East
Dina	West
Joseph	North

I am trying to create a visualisation table, I want it to look like the one below:

If the School Name in table 1 and 2 are are not the same show the name of the school in Shool Name 2 column but if it is the same do not show it on column Shool Name2. Then after I also want to count them in the table below the number will be 2 (North and East):

I have tried the following dax measures but they are not working:

BlankIfNotSameSchool =

VAR SchoolName1 = SELECTEDVALUE('Table_1'[School])

VAR SchoolName2 = SELECTEDVALUE('Table_2'[School])

RETURN

    IF(

        NOT(ISBLANK(SchoolName1 )) &&

        SchoolName1 = SchoolName2,

        BLANK(),

        SchoolName2

    )

Name	School Name1	School Name2
Jane	East	North
France	East
Crage	West	East
Dina	West
Joseph	North

[tamerj1]

Hi @mighty 

what is the relationship between the two tables? Which name column is used in the table visual?

[mighty]

Hi @tamerj1 

It is a many to many relationship pointing only in 1 direction. I am uisng both column name. Actually to clarify,

Table_1

Name	Preferred School
Jane	East
France	East
Crage	West
Dina	West
Joseph	North

Table_2

Name	Not Preferred School
Jane	East
France	East
Crage	West
Dina	West
Joseph	North

Table Visual should look like the following:

Name	Preffered School	Not Preferred School
Jane	East	North
France	East
Crage	West	East
Dina	West
Joseph	North

[tamerj1]

@mighty 

I suppose table1 filters table2. But many to many? That seems to be a bit confusing! If based on [Name] I suppose it is unique in both tables?

[mighty]

@tamerj1 that is correct table1 filters table2, how the relationship based is based on the email address, a column I did not include, apologies for causing confusion.

Sample data:

Table1

Name	Preferred School	Email
Jane	East	jane@gmail.com
France	East	france@gmail.com
Crage	West	crage@gmail.com
Dina	West	dina@gmail.com
Joseph	North	joseph@gmail.com

Table2

Name	Preffered School	Not Preferred School	Email
Jane	East	North	jane@gmail.com
France	East		france@gmail.com
Crage	West	East	crage@gmail.com
Dina	West		dina@gmail.com
Joseph	North		joseph@gmail.com