Append two filtered tables

[Anonymous]

I have two tables that are the exact same so that I can filter data in two differnet ways usign slicers. What I need is a DAX command to create an appended table of these two after slicers have been used, but I can not seem to find a way. The table functions either seem to appened before the filter or when I try a crossjoin the resulting table relationships filter out those selections from table 1. 

Table1 

Location A

Location B

Table 2 

Location F

Result 

Location A,B,F 

[vitorek]

@Anonymous I have the same use case and used

all_table = UNION(table1, table2, table3) 

However resulting all_table doesn't respect filtered values in slicers for table1 table2 table3.

[amitchandak]

@Anonymous , merge in power bi or Append and aggregate in power bi

https://radacad.com/append-vs-merge-in-power-bi-and-power-query

https://radacad.com/power-bi-aggregation-step-1-create-the-aggregated-table