You can't do it the ways you have tried if you haven't connected the 2 data sources somehow.
You might want to try it with a Parameter, but I think you'll have the same issue. The 2 data sources have to blended or joined somehow or Tableau doesn't have a means of applying a filter to both sources.
1 of 1 people found this helpful
actually this worked.