Left join in dax

Question

Hi all,&nbsp;&nbsp;What method should I be using if I were to achieve the same results as below?&nbsp;SQL query:&nbsp;&nbsp;&nbsp;&nbsp;It is similar to this:&nbsp;Customer Table&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Customer_details Table:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Expected Results (measure):&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;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.&nbsp;Thank you!&nbsp;

v-chuncz-msft · Accepted Answer

Anonymous,
&nbsp;
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]
    )

Forum Discussion

Left join in dax

1 Reply

Related content

Natural Left Outer Join in DAX?

Left anti-join in DAX

Left Join

left join in Report

Issue with left join using measures