Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

Left join in dax

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               Cust...
Need Help
Show and Tell
  • v-chuncz-msft's avatar
    v-chuncz-msft
    9 years ago

    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]
    )
v-chuncz-msft's avatar
v-chuncz-msft
Community Support
9 years ago

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]
    )