Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

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                            ...
Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    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's avatar
Anonymous
Not applicable
7 years ago

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's avatar
Anonymous
Not applicable
7 years ago

Anonymous 

 

This works as I need thanks!