Aggregate Month End Percentages

Question

Say I have the following table:&nbsp;Measure A&nbsp; &nbsp; &nbsp; &nbsp; Measure B&nbsp; &nbsp; &nbsp; Month5&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;10&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Jan3&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;30&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Jan6&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;10&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Feb3&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 5&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Feb40&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 50&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Mar&nbsp;What I need to do through DAX is this -Get (A/B)% for each month: So Jan is (8/40)*100%, Feb is (9/15)*100% and Mar is 40/50*100%Once I get Jan as 20%, Feb as 60% and March as 80% I need to average these three values --&gt; (20+60+80)/3 = 53.33&nbsp;How can I do this in dax ?

jihwan_kim · Accepted Answer

Hi,
I assume measure A and measure B are columns.
Please check the below picture and the attached pbix file.
&nbsp;

&nbsp;
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

Forum Discussion

Aggregate Month End Percentages

1 Reply

Related content

Month on Month variance percentage

Month on month percentage changes

Aggregate percentage column

Percentage of month by ID

Calculate previous month aggregate amount