Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi All,
How could I create a column in "ProductMaster" table, with a sum of the "linetotal" column in "OrderDetail_All" table, filtered by the "productID" column. A simple SUM gives me the sum of all the values ando not by ProductID.
Regards
Solved! Go to Solution.
Hi, @Anonymous
You can try the following methods.
Sample data:
Column =
CALCULATE (
SUM ( OrderDetail_All[LindTotal] ),
FILTER ( OrderDetail_All, [ProductID] = EARLIER ( ProductMaster[ProductID] ) )
)
Is this the result you expect?
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Hi, @Anonymous
You can try the following methods.
Sample data:
Column =
CALCULATE (
SUM ( OrderDetail_All[LindTotal] ),
FILTER ( OrderDetail_All, [ProductID] = EARLIER ( ProductMaster[ProductID] ) )
)
Is this the result you expect?
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
What are your relationship keys between those two tables ? Make sure that direction is 1-M and cross filtering is set to single.
Also share the DAX of your "Total sales" Measure.
Proud to be a Super User!
@Anonymous , It should do the correct sum, Unless
1. Join is inactive
2. You are using product ID from another table
3. You have a measure where you have used all or allselected , or filter without filter function
User | Count |
---|---|
97 | |
87 | |
77 | |
67 | |
63 |
User | Count |
---|---|
111 | |
96 | |
96 | |
67 | |
63 |