Get total of measured table values

[ScablandKing]

I have this measure which counts to 288 on my table which is correct

311 New 0 Remain = SUMX(VALUES('Checklists'[Checklist]), IF([311 Remaining]<0,0,[311 Remaining]))

How do I return the total of that as a sum? I need that 288 number for another measure?

[Greg_Deckler · Accepted solution]

@ScablandKing 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 · Accepted solution]

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

[ScablandKing · Accepted solution]

Measure 3 = SUMX(SUMMARIZE('C24 ADH','C24 ADH'[Checklist],"MAX",[311 New 0 Remain]),[MAX])

[ScablandKing]

@Greg_Deckler 

I can get MAXX to work but how can I sum or total this population?

Measure = MAXX(SUMMARIZE(Checklists,Checklists[Checklist],"MAX",[311 New 0 Remain]),[MAX])

[ScablandKing]

SUMX DUH. It's definitely monday!!

[Greg_Deckler]

@ScablandKing Ha! Glad you got it!

[amitchandak]

@ScablandKing , Try

311 New 0 Remain = calculate( SUMX(VALUES('Checklists'[Checklist]), IF([311 Remaining]<0,0,[311 Remaining])), allselected()) 

[ScablandKing]

Not working

311 New% = CALCULATE(SUMX(VALUES('Checklists'[Checklist]), IF([311 Remaining]<0,0,[311 Remaining])),ALLSELECTED())