Forum Discussion

jesly_ajin's avatar
jesly_ajin
Helper III
3 years ago
Solved

Calculate measure / values using 2 non-dependent tables

Hi, Below is the relation between my tables. I need to calculate a value based on columns from Tables C & D or B & C. Example: 'B'[Total] * 'C'[Engine_On] Please help me achieve this as I am unabl...
Need Help
Show and Tell
Tips and Tricks
  • v-jianboli-msft's avatar
    v-jianboli-msft
    3 years ago

    Hi jesly_ajin ,

     

    If there is no relationship between these two tables, how do you determine the correspondence between the two columns you want to multiply? You can multiply them together by using aggregated values

    e.g. MAX('B'[Total]) * MAX('C'[Engine_On])

     

    Here is my sample data:

     

     

    Measure = MAX('B'[Total])*MAX('C'[Engine_On])

     

    Output:

    Best Regards,

    Jianbo Li

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-jianboli-msft's avatar
v-jianboli-msft
Community Support
3 years ago

Hi jesly_ajin ,

 

If there is no relationship between these two tables, how do you determine the correspondence between the two columns you want to multiply? You can multiply them together by using aggregated values

e.g. MAX('B'[Total]) * MAX('C'[Engine_On])

 

Here is my sample data:

 

 

Measure = MAX('B'[Total])*MAX('C'[Engine_On])

 

Output:

Best Regards,

Jianbo Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.