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

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

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
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

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