two dimensional relationship

Hi visittokiran ,

For your needs, it seems to be easier to use DAX.

You can create the following measure

total consumers from table2 =
CALCULATE (
    SUM ( 'data table 2'[total consumers] ),
    FILTER ( 'data table 2', [month-year] = MAX ( 'Calendar'[MonthYear] ) )
)

When you filter MonthYear, the results is as follows.

You want to calculate the ratio, just create the following

Ratio = DIVIDE(SUM('data table 1'[Consumer affected]),[total consumers from table2])

Best Regards,

Stephen Tao

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