Forum Discussion
Multiplying Columns In Different Tables With Relationships - Calculated Column of Measure
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!!
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
2 Replies
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