creating table from multiple other tables

[bacon6actual]

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?

[bacon6actual]

Thanks Bud!!!!

[samdthompson · Accepted solution]

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

[Anonymous]

=
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?