Need help with creating visual interactions between two tables

[Anonymous]

Hey guys, 

I want to have two graphs: the first graph is based on Table 1 and should reflect the variance in the value by product; for the second graph i need to recalculate the difference between variance and threshold in the table 2 to input as a value and show it by asset category. Two graphs should interact with each other; for example, when I click on the Bike category in graph 2 i should see Products filtered out on graph one. I need help with the formula for the graph 2.

Table 1
Asset Category	Actual	Budgeted	Variance	Product
Bikes	50	40	10	Bike 1
Bikes	60	70	-10	Bike 2
Bikes	20	30	-10	Bike 3
Bikes	170	260	-90	Bike 4
Mopeds	110	50	60	Moped 1
Mopeds	90	50	40	Moped 2
Table 2
Asset Category	Actual	Budgeted	Variance	Threshold	Material Difference
Bikes	300	400	-100	90	Yes
Mopeds	200	100	100	80	Yes

Appreciate any help!

[amitchandak]

@Anonymous , You can create and a common asset table/dimension and use that for analysis

asset = distinct(union(all(Table1[Asset]),all(Table2[Asset])))