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 |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
118 | |
101 | |
71 | |
61 |