Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
105 | |
101 | |
79 | |
72 | |
64 |
User | Count |
---|---|
142 | |
108 | |
101 | |
81 | |
74 |