Forum Discussion

bacon6actual's avatar
bacon6actual
Frequent Visitor
10 years ago
Solved

creating table from multiple other tables

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 sin...
  • samdthompson's avatar
    samdthompson
    10 years ago

    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

samdthompson's avatar
samdthompson
Memorable Member
10 years ago

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's avatar
Anonymous
Not applicable
8 years ago

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