Measure that calculates values from different columns

[lrnt12]

Hello Community,

I have quite a challenge here. I got these two tables, many-to-one relationship:

                             Table1                                    Table2   

 

What I'm trying to do is to create a measure that will calculate the following expression: Value + (Numerator/Area).  

Any suggestion is highly appreciated!

[MFelix · Accepted solution]

Hi @lrnt12,

You should create a measure that looks like this:

Calculated Measure =
IFERROR (
    CALCULATE (
        SUMX ( Table1; Table1[Value] + Table1[Numerator] / SUM ( Table2[Area] ) )
    );
    BLANK ()
)

You should use the Mark from Table 1 to make this work

Regards,

MFelix

[lrnt12]

Thanks a lot, Felix! Works like a charm!