Multiplying Columns In Different Tables With Relationships - Calculated Column of Measure

[Anonymous]

Community,

Having not much experience with DAX I am having trouble with the following;

Below are my sample tables, their relationships and the values 

I would like to be able to multiply the "Raw Data" in the data table by the "Weightings" in the weightings table.

Should this be a measure or calculated column?

Do I need to create an additional table in modeling to do this?

Any help would be much appreciated!!

[Anonymous · Accepted solution]

Hi @Anonymous ,

I dont think you need any additional table.

There is already a relationships between these two tables.

You can use either a quick measure , measure or  calculated column for this :

1. Quick Measure 

2. DAX measure 

Measure = Sumx('Data Table','Data Table'[Raw Data]*related(weightings[weightings]))

3. calculated column

Column = 'Data Table'[Raw Data]*RELATED(weightings[weightings])

the answers is going to be the same.

Look at my output.

let me know for any question.

Thanks,

Tejaswi

[Anonymous]

@Anonymous 

This works as I need thanks!