we are using Tableau 10.4.
We have specific requirement to create drill through from one dashboard to another while using select actions.
The problem appears when we try to combine worksheets that use separate data sources with relationship over one field.
The requirement that limits drill through and filtering functionality is that we need to have different primary data sources for each worksheet on second dashboard because of restrictions on plotting capability.
Please find detailed description of our problem in attached file where we described few solutions that we tried and their disadvantages .
I was able to find this Tableau Community post that I believe has a solution for the above scenario worked out already.
I would review the above community post for designing the desired view.
I hope this helps!