cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
SteveG_91
Helper I
Helper I

Sum After Grouping

I have a table named "OBJECT" with the following structure and values

 

ProductNumberProductIdUnits
00561850
00561850
011600350
011601150
011600350
011601150
015600400

 

I'm trying to write a measure to sum the 'Units' after grouping by 'ProductNumber' and 'Product Id'.  My result should be one record per 'ProductNumber' with the sum of 'Units'.  It should look like this:

 

ProductNumberUnits
00550
011500
015400

 

I've tried various combinations of SUM, SUMX, and SUMMARIZE to no avail.

 

Thanks in advance.

1 ACCEPTED SOLUTION
Shaurya
Memorable Member
Memorable Member

Hi @SteveG_91,

 

I would start this by removing the duplicate rows first and getting this table:

 

Screenshot 2022-10-06 064312.jpg

 

The following DAX Formula can then be used to group by ProductNumber and add the Units values:

 

Result = SUMMARIZE('Table','Table'[ProductNumber],"Units",SUM('Table'[Units]))

 

Here's the result:

 

Screenshot 2022-10-06 064547.jpg

 

Works for you? Mark this post as a solution if it does!

View solution in original post

2 REPLIES 2
SteveG_91
Helper I
Helper I

Than worked Shaurya, thank you!  Should have thought of that myself.

Shaurya
Memorable Member
Memorable Member

Hi @SteveG_91,

 

I would start this by removing the duplicate rows first and getting this table:

 

Screenshot 2022-10-06 064312.jpg

 

The following DAX Formula can then be used to group by ProductNumber and add the Units values:

 

Result = SUMMARIZE('Table','Table'[ProductNumber],"Units",SUM('Table'[Units]))

 

Here's the result:

 

Screenshot 2022-10-06 064547.jpg

 

Works for you? Mark this post as a solution if it does!

Helpful resources

Announcements
November 2022 Update

Check it Out!

Click here to read more about the November 2022 updates!

Microsoft 365 Conference â__ December 6-8, 2022

Microsoft 365 Conference - 06-08 December

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Power BI Dev Camp Session 27

Ted's Dev Camp

This session walks through creating a new Azure AD B2C tenant and configuring it with user flows and custom policies.