Forum Discussion
yaman123
Post Partisan
Post PartisanRunning Total on a Measure Not Working
Hi, I am looking to calculate the running total per month from the below measure which gives the 'phased' value per month for the previous year (basically total number of complaints per yer divi...
Greg_Deckler
Community Champion
Community Championyaman123 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.