Append two filtered tables

Question

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

amitchandak · Answer

Anonymous , merge in power bi or Append and aggregate in power bi 
https://radacad.com/append-vs-merge-in-power-bi-and-power-query
&nbsp;
https://radacad.com/power-bi-aggregation-step-1-create-the-aggregated-table
&nbsp;

anonymous · Answer

@Anonymous I have the same use case and usedall_table = UNION(table1, table2, table3)&nbsp;However resulting all_table doesn't respect filtered values in slicers for table1 table2 table3.

Forum Discussion

Append two filtered tables

2 Replies

Related content

Append table kpi's

Filtered table

Dataflow - Append

Table append issue

Appending and Merging tables