Dynamically join tables with filters values from Slicer

[ams123]

I am trying to have a dynmaic table that is the union of the other tables that have relationships and slicers.

Systems are linked to specific subsystems which are linked to specific components.  Selecting a specific system via slicer will filter the subsystem and components as expected in their individual timing charts.  I have individual timing charts for all there which work as intended but when I utilize a Power Querry Append or DAX Union to create a single timing table and chart I don't get the slicer filtering to carry over.  Since a table can only have one relationship I cannot link all the relationships to make the slicers vwork directly.

I have file that demostrates the issue but not sure how to share it.

[v-jiascu-msft]

Hi @ams123,

1. You can upload the file to the cloud drive like OneDrive, GoogleDrive and then share the download link here.

2. The calculated table can't respond to the slicers. 

3. What's the expected result?

Best Regards,
Dale

[ams123]

1) Here is my demo file

https://1drv.ms/u/s!AlfwErB6m5JThTQzvqKm2LDKuMxg

Is there another way to build the table so it will be the combination of the sliced tables.

[v-jiascu-msft]

Hi @ams123,

What's the expected result? 

Would like to integrate the three tables into one? Maybe the fields of the slicers should be from the One table [Timing].

Best Regards,
Dale

[ams123]

I have three unique timing elements {systems, subsystems, componets} which all have relationships so when you select one system you filter down subsystems and components.  This can be seen in the individual timing tables.  I want the overall timing table to filter down in the same why via the slicers, select one system and the subsystems and components are filtered.

[v-jiascu-msft]

Hi @ams123,

Establishing a relationship like the snapshot shows could help. Please give it a try.

Best Regards,
Dale