Forum Discussion

newbie74's avatar
newbie74
Frequent Visitor
6 years ago

Calculate with values from different tables

Hello Community, (big thanks already for the endless answers i got by browsing this forum!)   Here is my problem - i want to create a measure that would output the total rebate in the example belo...
Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
6 years ago

Perhaps try something like this:

 

 

Measure =
  VAR __Table =
    ADDCOLUMNS(
      ADDCOLUMNS(
        SUMMARIZE(
          'TURNOVER',
          [customer],
          "__EUROrder",SUM('TURNOVER'[EUR Order])
        )
        "__Rebate",LOOKUPVALUE('REBATE'[rebate],'REBIATE'[customer],[customer])
      ),
      "__Total",[__EUROrder] * [__Rebate]
    )
RETURN
  SUMX(__Table,[__Total])

 

 

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi newbie74 

I assueme both table are connected on Customer.

 

Drag customer, EUR order from first table and rebate from second table into table visual.

 

New Measure=Sumx(table1,table1[Eur ORder]*related(table2[Rebate]))

 

Thanks & regards,
Pravin Wattamwar
www.linkedin.com/in/pravin-p-wattamwar

If I resolve your problem Mark it as a solution and give kudos.