Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

SUMX FROM 2 DIFFERENT TABLES (DAX)

Hi Guys,   Newbie here !   Just wanna ask how to sumx from 2 different tables?   Thank you!  
Need Help
  • Jimmy801's avatar
    Jimmy801
    6 years ago

    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

  • edhans's avatar
    edhans
    6 years ago

    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. 

dondanni's avatar
dondanni
New Member
4 years ago

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's avatar
edhans
Icon for Community Champion rankCommunity Champion
4 years ago

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.