topic Re: Please assist with the following dax in DAX Commands and Tips

Please assist with the following dax

mighty — Sun, 27 Aug 2023 18:46:14 GMT

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

Re: Please assist with the following dax

tamerj1 — Sun, 27 Aug 2023 18:59:16 GMT

Hi mighty

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

Re: Please assist with the following dax

mighty — Sun, 27 Aug 2023 19:09:10 GMT

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

Re: Please assist with the following dax

tamerj1 — Sun, 27 Aug 2023 20:16:20 GMT

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?

Re: Please assist with the following dax

mighty — Sun, 27 Aug 2023 20:42:25 GMT

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