Left join in dax

[Anonymous]

Hi all, 

What method should I be using if I were to achieve the same results as below?

SQL query:

It is similar to this:

Customer Table

Customer_details Table:

Expected Results (measure):

I would like to show only matched cust_id from two separate tables and sum the total up! Hopefully someone can guide me through this. 

Thank you!

[v-chuncz-msft · Accepted solution]

@Anonymous,

You may use DAX below to add a measure to Customer table.

Measure =
VAR Cust_id =
    MAX ( Customer[Cust_id] )
RETURN
    SUMX (
        FILTER ( Customer_details, Customer_details[Cust_id] = Cust_id ),
        Customer_details[Total]
    )