Forum Discussion
Calculate Sum from another table for matching values
I have 2 tables. One with people and payments. The other with a couple selected names that I want sums for. I need this as a table. table1 name amount bob 10 joe 5 mike 7 bob 5 mike 2 t...
Hi bshimamoto,
You don't need to create sum measure, when add it to table, it will sum automatically
If you want to use another table(table2) in filter, you need to make sure there is a realtionship between two tables, then it will work.
Best Regards,
Zoe ZhiIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Bump!
daxCommunity Support
Hi bshimamoto,
You don't need to create sum measure, when add it to table, it will sum automatically
If you want to use another table(table2) in filter, you need to make sure there is a realtionship between two tables, then it will work.
Best Regards,
Zoe ZhiIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.