Use same filter value for to separated tables

[MeMedesimo]

Hi there,

I am trying to create an interactive dashboard that will show 2 visuals once the user selected the desired filter.

Let's say I have the following two files loaded into PowerBi Desktop:

COUNTRY	GENDER	TOTAL COSTUMERS
USA	M	45
USA	F	65
UK	M	67
UK	F	86
FINLAND	M	23
FINLAND	F	21
SPAIN	M	13
SPAIN	F	15

and

COUNTRY	AGE BAND	TOTAL COSTUMERS
USA	Child	56
USA	Adult	75
UK	Child	34
UK	Adult	98
FINLAND	Child	23
FINLAND	Adult	45
SPAIN	Child	65
SPAIN	Adult	23

I am trying to create 2 visuals (one for GENDER and one for AGE BAND) and I would like to create a unique filter for COUNTRY so that once the user selects USA only, the 2 visuals updates automatically.

Unfortunately, I need to put both filters in the "Filters on this page" section to control both visuals, whereas I would like just to have one since the values in COUNTRY are the same, but due to the duplicates, I can't join.

Thanks

Simone

[johnt75 · Accepted solution]

Create a separate Country dimension table using

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

create relationships from the new table to both existing tables and then place your filter on the new table.