Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Hi Guys,
Newbie here !
Just wanna ask how to sumx from 2 different tables?
Thank you!
Solved! Go to Solution.
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
Jimmy
If 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.
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingIt worked from my side.
Hello @Anonymous
have you been able to solve the problem with the replies given?
If so, 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
All the best
Jimmy
If 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.
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingHi @Anonymous ,
Kindly share your sample data and excepted result to me if you don't have any Confidential Information. Please upload your files to One Drive and share the link here.
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
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.
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.
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI Reporting