March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
Register NowGet certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
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())
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
Check out the November 2024 Power BI update to learn about new features.
User | Count |
---|---|
121 | |
98 | |
86 | |
69 | |
61 |
User | Count |
---|---|
140 | |
121 | |
108 | |
99 | |
96 |