Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers. Get Fabric certified for FREE! Learn more
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?
Solved! Go to 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 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.
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])
SUMX DUH. It's definitely monday!!
@ScablandKing Ha! Glad you got it!
@ScablandKing , Try
311 New 0 Remain = calculate( SUMX(VALUES('Checklists'[Checklist]), IF([311 Remaining]<0,0,[311 Remaining])), allselected())
Not working
311 New% = CALCULATE(SUMX(VALUES('Checklists'[Checklist]), IF([311 Remaining]<0,0,[311 Remaining])),ALLSELECTED())