Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Help with Multiply columns by reference table

  Hi,    I need help with multiplying different columns. First, sum columns Sales and Pro then muliply it by the Growth from the other table when it match the name.    I've done with the vlookup...
General Comment
Interesting Links
Tips and Tricks
Tutorial Requests
  • sokg's avatar
    sokg
    7 years ago

    First you have to create a relationship as pic below.

     

    then write these measures

     

    Growth A Measure =
SUMX (
    'Sales Table';
    'Sales Table'[Sale] * 'Sales Table'[Pro]
        * RELATED ( 'Growth Table'[Growth A ] )
)

    and

     

    Growth B Measure =
SUMX (
    'Sales Table';
    'Sales Table'[Sale] * 'Sales Table'[Pro]
        * RELATED ( 'Growth Table'[Growth B] )
)

    and the result is

     

sokg's avatar
sokg
Solution Supplier
7 years ago

First you have to create a relationship as pic below.

 

then write these measures

 

Growth A Measure =
SUMX (
    'Sales Table';
    'Sales Table'[Sale] * 'Sales Table'[Pro]
        * RELATED ( 'Growth Table'[Growth A ] )
)

and

 

Growth B Measure =
SUMX (
    'Sales Table';
    'Sales Table'[Sale] * 'Sales Table'[Pro]
        * RELATED ( 'Growth Table'[Growth B] )
)

and the result is

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Thank you, but I faced a little problem for some reason I was getting divided by two.  I just added ' *2 '  at the end. It works.