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
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
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

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

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

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