topic creating table from multiple other tables in DAX Commands and Tips

creating table from multiple other tables

bacon6actual — Wed, 24 Aug 2016 04:11:38 GMT

I have a report with multiple data tables. Four of them have a column that is named agency with similar data. I want to take the distinct values from all four tables and create a new table with a single agency column that has distinct values from the other four tables. Basically I want to do what union does with more then two tables. Can someone explain how I do this?

Re: creating table from multiple other tables

samdthompson — Thu, 25 Aug 2016 22:07:21 GMT

Hi, welcome to the community, try this: Go to the modelling tab on the ribbon and click create new table. In the formula bar use the DAX expression

=
SUMMARIZE (
    UNION (
        ALL ( Table1[UniqueValue] ),
        ALL ( Table2[UniqueValue] ),
        ALL ( Table3[UniqueValue] ),
        ALL ( Table4[UniqueValue] )
    ),
    [UniqueValue]
)

//If this solves your question please mark as such

Re: creating table from multiple other tables

bacon6actual — Fri, 26 Aug 2016 04:47:33 GMT

Thanks Bud!!!!

Re: creating table from multiple other tables

Anonymous — Mon, 11 Dec 2017 19:48:04 GMT

=
SUMMARIZE (
    UNION (
        ALL ( Table1[UniqueValue] ),
        ALL ( Table2[UniqueValue] ),
        ALL ( Table3[UniqueValue] ),
        ALL ( Table4[UniqueValue] )
    ),
    [UniqueValue]
)

What is this unique value line at the end supposed to be?