Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello,
I have 2 tables with a many to many relationship. I need to sum the costs from table 1 but filter based on the other table.
The RELATED function doesnt work for me because of the many to many relation. How can I still realize to sum it?
Thanks in advance
Hi @Anonymous
if you want to create a column, please try some dax expression like the following :
Column =
CALCULATE(
SUM( 'Table (1)'[cost] ),
FILTER( 'Table (2)', the filter conditions )
)
if you want calculate values in visual, you can just put the field from table 2 in the Filters and sum() function will keep the filter.
Best Regards
Community Support Team _ chenwu zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@Anonymous , You need to use relatedtable in sumx
new column in table 1 =
sumx(relatedtable(Table2), Table2[Value])
refer 4 ways to copy data from one table to another
https://www.youtube.com/watch?v=Wu1mWxR23jU
https://www.youtube.com/watch?v=czNHt7UXIe8