Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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!
Solved! Go to 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] )
@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] )
User | Count |
---|---|
141 | |
113 | |
104 | |
78 | |
64 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |