Calculate measure / values using 2 non-dependent tables

[jesly_ajin]

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.

[v-jianboli-msft · Accepted solution]

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.