Trying to achieve a filter equivalent to multiple relationships

[LairdLight]

Hi - I'm not sure if what I'm trying to do is achievable, I'm a novice at any kind of coding so any kind of help would be much appreciated....

I have a table with unique 'Application Group' values like this:

AppGroup	SME	Phase
x	John	1
y	Laura	2
z	Steve	3

I then have a table with a row per integration between a source 'Application Group' and a destination 'Application Group' field, both of which are derived from the same 'Application Group' filed in the first table. Like this:

Integration	SourceAppGroup	DestinationAppGroup
d1	x	y
f1	y	x
f2	y	z
h7	z	x

I want to be able to filter my second table (and any associated visuals) using the application group field in the first table - where an application group appears as either a source or a destination. I've tried a few things but nothing I'm trying seems to work.

Thanks 

[Phil_Seamark · Accepted solution]

Hi @LairdLight

This is a little rough but might be ok.

I created a new table based on your 2nd table but doubled the rows and introduced a Link column

Table 2 = UNION(
                    ADDCOLUMNS(Integration,"Link Column",'Integration'[SourceAppGroup]) ,
                    ADDCOLUMNS(Integration,"Link Column",'Integration'[DestinationAppGroup])
                )
				

This generates the following based on your sample data

I could then create a relationship from the new table to the slicer table using the new Link Column

Now on my report page, if I use a slicer over the Application Group, my visual based on the new table responds they way I think  you want it to.

[LairdLight]

Hi @Phil_Seamark

I've just applied your suggestion in my data model and it's definitely achieving the result I was aiming for.

Thanks very much for taking the time to solve this, much appreciated.