Skip to main content
cancel
Showing results for 
Search instead 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

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!:
The Definitive Guide to Power Query (M)

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!:
The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...

Thank you this worked! 🙂

Helpful resources

Announcements
Europe Fabric Conference

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.

July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

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

Top Solution Authors
Top Kudoed Authors