Measure with related and sumx

[Anonymous]

Hi all,

I have created some variables in a measure, and now I want to multiply the first variable with related value from another table)

For example:

var = test 1
 CALCULATE(
    SUMX('TableName';'Tablename1'[ColumnName1]);
    'TableName1'[ColumnName2] IN 
    { 
      12;
      13
     }
)
var = 2 test
   CALCULATE(
      SUMX(
          Name of variable name * RELATED ('TableName2'[ColumnName3]))
return 2 test

The measure doesn't work. Can someone please help me with the measure above? 
Thank you

[v-lili6-msft · Accepted solution]

HI, @Anonymous 

Sample data and expected output would help tremendously.
Please see this post regarding How to Get Your Question Answered Quickly:
https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

Regards,

Lin