Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get 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

Reply
ScablandKing
Regular Visitor

Get total of measured table values

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]))

 

 

table2.png

 

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

2 ACCEPTED SOLUTIONS
Greg_Deckler
Super User
Super User

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



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Power BI Cookbook Third Edition (Color)

DAX is easy, CALCULATE makes DAX hard...

View solution in original post

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

View solution in original post

7 REPLIES 7
Greg_Deckler
Super User
Super User

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



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Power BI Cookbook Third Edition (Color)

DAX is easy, CALCULATE makes DAX hard...

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

@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])

 

 

SUMX DUH. It's definitely monday!!

@ScablandKing Ha! Glad you got it!



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Power BI Cookbook Third Edition (Color)

DAX is easy, CALCULATE makes DAX hard...
amitchandak
Super User
Super User

@ScablandKing , Try

 

311 New 0 Remain = calculate( SUMX(VALUES('Checklists'[Checklist]), IF([311 Remaining]<0,0,[311 Remaining])), allselected()) 
Join us as experts from around the world come together to shape the future of data and AI!
At the Microsoft Analytics Community Conference, global leaders and influential voices are stepping up to share their knowledge and help you master the latest in Microsoft Fabric, Copilot, and Purview.
️ November 12th-14th, 2024
 Online Event
Register Here

Not working

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

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.

Nov PBI Update Carousel

Power BI Monthly Update - November 2024

Check out the November 2024 Power BI update to learn about new features.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.