Forum Discussion
Solved
Average Ticket Completion Time
Hi I connect to an SQL dataset using the DirectQuery option and the table I am having a problem with is the one in the image attached. IssueNumber, CreatedOn & ResolvedOn are all from IssuesView ...
DJsummers 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.
Greg_Deckler Greg pulls through for me again! Thanks man, that works a treat. Very much appreciated.