Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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! 🙂