Multiply values in columns (Different tables)

If you know that there will only be 1 entry per item in the 2nd table then you can create a one-to-many relationship between the tables. You would then be able to use the RELATED function to do the multiplication. e.g. you could create a column on the first table like

Multiplied value = 'Table 1'[Value] * RELATED('Table 2'[Value])

Firstly you can create a relationship between the two tables based on the common column. Now you can use the below DAX to do the multiplication -

Multiply = TABLE1[COLUMN1]* RELATED(TABLE2[COLUMN2])

Model Should look something like this, just a sample image -

 

Let me know if this helped you.

Firstly you can create a relationship between the two tables based on the common column. Now you can use the below DAX to do the multiplication -

Multilple = TABLE1[COLUMN1]* RELATED(TABLE2[COLUMN2])

Model Should look something like this, just a sample image -

 

Let me know this helped you.

can you share a picture of the diagram view showing the relationship between the tables ?

This works for most categories: 

But for certain others it's completely wrong... why would that be? 

Hi Anonymous 
My Undestanding that you cannot create calculated columns and you cannot create or edit relationships. Then try to create New Measure

NewMeasure =
SUMX (
    Table1,
    VAR Name = Table1[Name]
    VAR Value1 = Table1[Value]
    VAR Value2 =
        MAXX ( FILTER ( Table2, Table2[Name] = Name ), Table2[Value] )
    RETURN
        Value1 * Value2
)