Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
jcastr02
Post Prodigy
Post Prodigy

Average of Monthly Totals

I am looking for a measure I could write that would be an AVERAGE of the monthly totals.   When I do an average for the column, it's giving me an average of each entry vs. the average of the monthly total.   Looking to get an average of the monthly totals.

 

average.png

1 ACCEPTED SOLUTION

Thank you this worked! 🙂

View solution in original post

4 REPLIES 4
Greg_Deckler
Super User
Super User

@jcastr02 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

The pattern is:
MinScoreMeasure = MINX ( SUMMARIZE ( Table, Table[Group] , "Measure",[YourMeasure] ), [Measure])
MaxScoreMeasure = MAXX ( SUMMARIZE ( Table, Table[Group] , "Measure",[YourMeasure] ), [Measure])
AvgScoreMeasure = AVERAGEX ( SUMMARIZE ( Table, Table[Group] , "Measure",[YourMeasure] ), [Measure])
etc.



Follow on LinkedIn
@ 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!:
Power BI Cookbook Third Edition (Color)

DAX is easy, CALCULATE makes DAX hard...

https://1drv.ms/u/s!Ava_12t7CNJtkRJxsfw9eIcdVKck?e=3TRwgq

 

@Greg_Deckler    Thank you for your help.  I tried to do first measure but struggling to get it to work - ARe you able to see my BI file? on the %Attrition by Month page -Data is coming from the HC and Terms table.  Thanks so much.  

@jcastr02 - Maybe: 

 

Measure = AVERAGEX(SUMMARIZE('HC and Terms',[Month],"__Count",SUM([Count])),[__Count])


Follow on LinkedIn
@ 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!:
Power BI Cookbook Third Edition (Color)

DAX is easy, CALCULATE makes DAX hard...

Thank you this worked! 🙂

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors
Top Kudoed Authors