Forum Discussion
SUMX FROM 2 DIFFERENT TABLES (DAX)
Hello Anonymous
just sum them 🙂
sumxtwice = SUMX('Table1';'Table1'[Column1])+SUMX('Table2';'Table2'[Column2])If this post helps or solves your problem, please mark it as solution (to help other users find useful content and to acknowledge the work of users that helped you)
Kudoes are nice too
Have fun
JimmyIf you need a single SUMX for two fields in different tables, use something like the following:
Measure = SUMX( TableName, TableName[Field] * RELATED(TableName2[DifferentField]) )The tables have to have a relationship, and this assumes you are going from the many table to the one table. For example, you are multiplying quantities in a sales fact table against the cost of goods from a product dimension table.
Community ChampionHello Anonymous
just sum them 🙂
sumxtwice = SUMX('Table1';'Table1'[Column1])+SUMX('Table2';'Table2'[Column2])
If this post helps or solves your problem, please mark it as solution (to help other users find useful content and to acknowledge the work of users that helped you)
Kudoes are nice too
Have fun
Jimmy
What if I want to use sumx table and multiply it with another another table on row leavel. (use first sumx as base table and multiply from another table on row leavel. )
sumxMultiply = SUMX('Table1';'Table1'[Column1]) * SUMX('Table2';'Table2'[Column2])
I think totla sum will be not be right.
- edhans
It won't be. You'd need to do it through a common dimension table
test measure = SUMX( Products, RELATED( table1[field] ) * RELATED( table2[field] ) )But that won't be right unless the product table is at the right granularity. You should probably do a merge in Power Query and do the math there.
But either way, this should be a new thread. This post was marked solved over a year ago.