Cross drill between Two matrix tables in Same Report Tab

Hi Maggie,

Thanks for the reply. 'Drill through filter' will work from tab to tab I believe. Please coorect me if I am wrong But in a single tab we are trying to achieve cross drill between two tables. 

The below screen shot you can see there are two matrix tables. Now if we drill up or down using the 'drill buttons' on top left of one table should also drill the second table. I tried using 'Drill filters other visuals' and 'edit interactions' available in format but not working as expected. This is the core issue of the post.

Please refer the below link, it should work similar to step 5 

https://docs.microsoft.com/en-us/power-bi/consumer/end-user-interactions

The below table is the out put we are trying to achevie. Normally we join the two tables with common dimensions and bring both measures in one table. But here joining is not possible as the secong table measure is calculated from ssas cube. so planning to overlay one matrix table over the other to show as one view. Only if the cross drill works we will be able to achieve this. 

Overlay means both table will be there in the same report tab but in second table we will hide all the dimensions and only measure2 will be visible. Then it will be aligned to the first table so it appears as single view. Will looks similar to below screen shot.