topic Append two filtered tables in DAX Commands and Tips

Append two filtered tables

Anonymous — Mon, 03 May 2021 15:14:28 GMT

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

Re: Append two filtered tables

amitchandak — Mon, 03 May 2021 16:27:36 GMT

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

Re: Append two filtered tables

Anonymous — Tue, 25 Jun 2024 06:50:42 GMT

@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.