Relationship ID mismatch leads to incorrect visual

[Anonymous]

Hi,

I have 2 tables which are connected through a 3rd table (unique IDs from Table1 as below). 

Table1_ID	Table1_ID_Unique	Table2_ID
A	A	A
B	B	B
C	C	C
D	D	E
A		F
B		G
C		A
D		B

Now when I filter my visual for E/F/G I see numbers for D, instead of blanks.

Directions between Table1 and Table1_unique is single, to Table1, between Table1_unique and Table2 it's both. I'm working on AAS through VS SSDT 2017, many-to-many is not possible. 

Please let me know how to fix this. 

[v-lid-msft]

Hi @Anonymous ,

How about the result after you follow the suggestions mentioned in my original post?Could you please provide more details about it If it doesn't meet your requirement?

Best regards,

Community Support Team _ Dong Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[v-lid-msft]

Hi @Anonymous ,

We can try to use the following formula to create  Table1_ID_Unique: 

Table1_ID_Unique =
DISTINCT ( UNION ( DISTINCT ( 'Table1'[ID] ), DISTINCT ( 'Table1'[ID] ) ) )

Best regards,

Community Support Team _ Dong Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Watsky]

You should have an inbetween Table that encompasses all of the unique values from both tables so instead of it showing just A,B,C,D it would show A,B,C,D,E,F,G. Create a reference table of table two then remove duplicates and append the results with Table1 Unique. Then change your cross filter direction to both on each side of Table1 Unique.