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 I'm bit lost here, the image you showed is after using solution I provided. send excel sheet with sample data and expected result.

PowerBIUser9901's avatar
PowerBIUser9901
Advocate II
7 years ago

Hi parry2k ,

Take a look at my previous post with the Power BI table created from your DAX formula. Notice that five rows of Order_ID 1200 exist. Table_1 has three occurrences of Order_ID 1200 while Table_2 has two occurreses of Order_ID 1200.

Since the Order_ID exist in both Table_1 and Table_2 the desired output is to only show the three rows of Order_ID 1200 from Table_1. The DAX Formula you suggested UNIONS both tables and shows five rows of Order_ID 1200.

 

Below is the excel sheet - I color coded it to show how it connects. I Appreciate your assistance.