Ability to filter values in different visualizations by any unrelated fields

[_dzhukov_]

Hello,

I have 2 separate tables with product attributes based on 2 separate data sources

Table 1:

ProductID	Attribute1	Attribute2	Attribute3	Attribute4	Attribute5	Attribute6
1	A	AA	AAA	AAAA	AAAAA	AAAAAA
2	B	BB	BBB	BBBB	BBBBB	BBBBBB
3	C	CC	CCC	CCCC	CCCCC	CCCCCC

Table 2:

ProductID	Attribute7	Attribute8	Attribute9	Attribute10	Attribute11	Attribute12	Attribute13	Attribute14	Attribute15
1	1	11					1111111		111111111
2	2	22					2222222		222222222
3	3	33					3333333		333333333

These tables have relationship through the "Product" dimension

I want to filter both tables at once by any field in each of the tables. 

For example, if in "Table 1" in the field "Attribute 5" I select the value "BBBBB", then the second table will be filtered by the field Product with the value 2. Assumptions, I can't create one big table with all attributes. This is a simplified example.

Please advise how can I do it?

[PC2790 · Accepted solution]

Hey @_dzhukov_,

If the relationship is there between the two tables, you can make the visuals interact with each other by using edit interactions. 

[amitchandak]

@_dzhukov_ , Check Treatas

https://www.sqlbi.com/articles/propagate-filters-using-treatas-in-dax/

https://docs.microsoft.com/en-us/dax/treatas-function