cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Frequent Visitor

## average of a measure

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

1 ACCEPTED SOLUTION
Community Support

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

Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the others find it more quickly.
3 REPLIES 3
Community Support

Hi @RubberNinja,

`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

Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the others find it more quickly.
Frequent Visitor

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

Community Support

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

Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the others find it more quickly.

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.