Aggregate Month End Percentages

Hi,

I assume measure A and measure B are columns.

Please check the below picture and the attached pbix file.

Expected result measure: =
VAR _newtable =
    ADDCOLUMNS (
        VALUES ( Data[Month] ),
        "@sumcolumnA", CALCULATE ( SUM ( Data[Measure A] ) ),
        "@sumcolumnB", CALCULATE ( SUM ( Data[Measure B] ) )
    )
RETURN
    AVERAGEX ( _newtable, [@sumcolumnA] / [@sumcolumnB] ) * 100