Forum Discussion

jesly_ajin's avatar
jesly_ajin
Icon for Helper III rankHelper 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 unable to find the table names while trying to create measures.

 

Thanks in advance.

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.

1 Reply

  • v-jianboli-msft's avatar
    v-jianboli-msft
    Icon for Community Support rankCommunity 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.