cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
vbourbeau
Resolver II
Resolver II

Average of average

Hi,

I want to do something probably easy but I don't figure it out. 

I have a mesure that is an average of value. When I do a table and regroup, the average always remains on all the data but I want to have it on the grouping value. Look bellow, the correct average should be 13.25...

 

Thank

 

2020-04-09 11_36_27-Window.png

1 ACCEPTED SOLUTION

@vbourbeau ,Try like

averagex(Summarize(Table,Table[id],"_1",average(Table[Value])),[_1])


Learn Power BI - Full Course with Dec-2022, with new DAX functions like Window, Index, Offset !!
Did I answer your question? Mark my post as a solution! Appreciate your Kudos !! Proud to be a Super User! !!
Formatted Profit and Loss Statement with empty lines

View solution in original post

5 REPLIES 5
Greg_Deckler
Super User
Super User

This looks like a measure aggregation problem. See my blog article about that here: https://community.powerbi.com/t5/Community-Blog/Design-Pattern-Groups-and-Super-Groups/ba-p/138149


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...
jthomson
Solution Sage
Solution Sage

There's plenty of solutions as to how to have a measure do a different calcuation dependent on if your measure is working on a total or not which is what you're going to want. Ignoring the fact that the results don't make sense given the data you've presented (the average of 5, 7 and 9 isn't 6.5), the total is calculating the average of all the data, which would be (5+7+9+20)/4, i.e. 10.25

az38
Community Champion
Community Champion

@vbourbeau  use smth like

= calculate(AVERAGEX(Table, AVERAGE('Table'[Value]) ) )

do not hesitate to give a kudo to useful posts and mark solutions as solution
LinkedIn

Same result

2020-04-09 12_03_03-Window.png

@vbourbeau ,Try like

averagex(Summarize(Table,Table[id],"_1",average(Table[Value])),[_1])


Learn Power BI - Full Course with Dec-2022, with new DAX functions like Window, Index, Offset !!
Did I answer your question? Mark my post as a solution! Appreciate your Kudos !! Proud to be a Super User! !!
Formatted Profit and Loss Statement with empty lines

Helpful resources

Announcements
Carousel_PBI_Wave1

2023 Release Wave 1 Plans

Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.

Power BI Summit Carousel 2

Global Power BI Training

Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!

Thank you 2022 Review

2022 Monthly Feature Releases

We had a great 2022 with a ton of feature releases to help you drive a data culture.