slicer to influence two DAX generated tables

[Anonymous]

I have two DAX generated tables with similar a similar column name:

Table1

Name     Age

Alpha     5

Beta       14

Gamma  22

Table2

Name     Age    other columns

Alpha     5          xx

Beta       14        xx

Gamma  22        xx

Alpha     12          xx

Beta       14        xx

Gamma  27        xx

I have a slicer called Name based on Table1. I want this slicer to also influence Table2.

I tried https://blogs.technet.microsoft.com/cansql/2016/12/19/relationships-in-power-bi-fixing-one-of-the-co... but this works in power query only. My DAX generated tables are not present in power query.

Is there a way to link them so this works?

[Stachu]

you need to either join the tables or create a virtual join with DAX
the simplest solution is to create a 3rd table that will only have unique names and join it with the 2 data tables with slicer on a new table
more complex options is using TREATAS to create virtual reltionship
https://www.sqlbi.com/articles/propagate-filters-using-treatas-in-dax/

[Anonymous]

Thanks for the suggestions @Stachu

can you suggest how best to make and link the third table? I am still relatively new to pbi

[Stachu · Accepted solution]

in DAX you can do it like this

Name Slicer = DISTINCT(UNION(VALUES('Table1'[Name]),VALUES('Table2'[Name])))

and then create a join to your data tables