Forum Discussion

PowerBIUser9901's avatar
PowerBIUser9901
Advocate II
7 years ago
Solved

Combining tables IF

I need to create a table visual with both Table_1 and Table_2 data merged however If Order_ID is included in Table_1 and Table_2 then only include the Table_1 data.   *Things to note both Table_1 a...
Need Help
  • parry2k's avatar
    parry2k
    7 years ago

    PowerBIUser9901 try this

     

    Table_Combine = 
UNION 
(
    DISTINCT( Table_1 ),
    DISTINCT(
        CALCULATETABLE(
            Table_2, EXCEPT( VALUES( Table_2[Order_Id] ), VALUES( Table_1[Order_Id] ) )
        )
    )
)
parry2k's avatar
parry2k
Super User
7 years ago

PowerBIUser9901 try union and distinct function

 

Go to modelling tab, data table and add following DAX. 

 

New Table = 
DISTINCT(
  UNION
      ( TABLE1, TABLE2 )
)
PowerBIUser9901's avatar
PowerBIUser9901
Advocate II
7 years ago

Hi parry2k ,

 

You DAX formula doesn’t address the logic of If Order_ID is included in Table_1 and Table_2 then only include the Table_1 row data.

 

Notice in the picture below by using your DAX formula if an Order_ID is in both Table_1 and Table_2 then it shows all row data associated to that Order_ID from both tables rather than just Table_1.