Max from a Measure that is created from 2 different measures.

[hsturm]

Hello,

I have two different tables, a date table and a Outage table that contains the meaures.

I have a measure (CAIDI Decimal) that I created by dividing the sum of two fields: 

'Outage'[(Sum Customer Seconds (from Duration)]/60)/'Outage'[Sum Customer Affected].

I'm now being tasked with getting the MAX from the CAIDI Decimal for the month for the last 5 years.

For example I'm wanting to show for the last 5 years the Max CAIDI Decimal is 80.195.
When I try to use the MAXX function MAX CAIDI Decimal = (MAXX(tableNane, [CAIDI Decimal]) I'm getting these large values in the last column.

[Greg_Deckler · Accepted solution]

@hsturm 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.

[hsturm]

@Greg_Deckler 
That worked. Thank you!