Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe 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.
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.
Solved! Go to Solution.
@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.
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])
Thank you this worked! 🙂