Slicer issue

[praveenpasila]

Hi All,

I am facing issue while trying to use one of the column as slicer.

Below is the data model structure

I wanted to use Name as slicer can some one please suggest how can we achieve this
Initially the cross filtering directin is single and then I have set to both.

I can see that the tables are connected using key so the filtering is also happening using keys

I want to use Name from Table1 and it is filtering data from Table1 correctly but data from Table3 instead of showing only
specific Names selected in slicer it is showing all the Names that are associated with that keys please see below

Can some one please suggest how to over come this scenario.

Thanks in advance

Below is the sample data 

Table1

Epic Key	Name
J-10	Amanda
J-16	Amanda
J-170	Amanda
J-171	Amanda
J-18	Amanda
J-10	Bruce
J-16	Bruce
J-170	Bruce
J-18	Shin

Table2

Epic Key

J-10

J-16

J-170

J-171

J-18

Table3

Epic Key	Name	Hrs
J-10	Amanda	10
J-16	Amanda	10
J-170	Amanda	10
J-171	Amanda	10
J-18	Amanda	5
J-10	Bruce	20
J-16	Bruce	20
J-170	Bruce	5
J-18	Shin	5

[johnt75 · Accepted solution]

Change the filter direction back to single on both relationships then create a new dimension table for names, e.g.

Names =
DISTINCT (
    UNION ( DISTINCT ( 'Table 1'[Name] ), DISTINCT ( 'Table 3'[Name] ) )
)

Link this new table to both table 1 and table 3 and use the column from the new table in your slicers and visuals.

[praveenpasila]

Thanks @johnt75  the solution worked

[praveenpasila]

got it thanks @johnt75  I tired similar bridge table approach but was facing some issues.

I will try the way you mentioned and will update the forum

Thanks again for your help