average of a measure

[RubberNinja]

Hello! I have just started using Power BI so I really need some help.

I have this measure:

And I want to get the mean of those values and looks something like this:

Is this possible? Thank you so much

[v-frfei-msft]

Hi @RubberNinja,

I made one sample for your reference.

Measure = CALCULATE(SUM(Table1[values]))

Measure 2 = SUMX(ALL(Table1),[Measure])/CALCULATE(COUNTROWS(Table1),ALL(Table1))

For more details, please check the pbix as attached.

https://www.dropbox.com/s/oy71br7yuyngbf6/average%20of%20a%20measure.pbix?dl=0

Regards,

Frank

[RubberNinja]

what if the values from my first column came from a measure also?

like these values came from

Measure = (SUMX(Control_Chart_View3, Control_Chart_View3[MidCallFailures]) / SUMX(Control_Chart_View3, Control_Chart_View3[Sessions])) * 100

sum() only accepts column reference, how can I get the sum of my values

[v-frfei-msft · Accepted solution]

Hi @RubberNinja,

I made a test by using your formula, it worked well as well.

Measure = (SUMX(Control_Chart_View3, Control_Chart_View3[MidCallFailures]) / SUMX(Control_Chart_View3, Control_Chart_View3[Sessions])) * 100

Measure 2 = SUMX(ALL(Control_Chart_View3),[Measure])/CALCULATE(COUNTROWS(Control_Chart_View3),ALL(Control_Chart_View3))

For more details, please check the pbix as attached.

https://www.dropbox.com/s/5fwlzhdpkf3qc27/average%20of%20a.pbix?dl=0

Regards,

Frank