Filters are not working - same filter for two table

[Bali21]

I have two data source which i combine with Full join on (Loc ID) and I want to use single filter for both the table BUT filter are showing wrong numbers for viz 1 as 3 required filter are coming from Table 2. I need to get the correct number for viz 1(decomposition tree) as well. Any much help appreciated!!

Table 1:

EMP name	Loc ID	Manager 3	Manager 2	Manager1
Rezza	33	John	Wade	Issac
Mark	33	John	Wade	Issac
Amy	22	John	Wade	Issac
Issac	33	John	Wade
Wade	77	John
Dab	444	Leena
Evan	333	Leena	Dab
lylla	111	Leena	Dab	Evan
Ray	111	Leena	Dab	Evan

Table 2:

Location Owner	Loc ID
Issac	33
Issac	22
Issac	44
Wade	77
Wade	88
John	55
John	66
John	99
Evan	111
Evan	222
Evan	555

ScreenShot of PBI without filter:

Once filter is applied Viz 1 not changing, it only applicable to table viz. Could you please suggest how it can be achived. So If I select "Issac" then both viz should be changes as per selection with correct count in Viz one as well.

Thank in Advance!

[VilmarSch · Accepted solution]

Veja se ajuda:

1. Criar uma tabela dimenção com os nomes unicos;
2. Faça o relacionamento desta com as outras duas;
3. Coloque esta terceira no filtro de página.