Forum Discussion
Sum After Grouping
I have a table named "OBJECT" with the following structure and values
| ProductNumber | ProductId | Units |
| 005 | 618 | 50 |
| 005 | 618 | 50 |
| 011 | 600 | 350 |
| 011 | 601 | 150 |
| 011 | 600 | 350 |
| 011 | 601 | 150 |
| 015 | 600 | 400 |
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:
| ProductNumber | Units |
| 005 | 50 |
| 011 | 500 |
| 015 | 400 |
I've tried various combinations of SUM, SUMX, and SUMMARIZE to no avail.
Thanks in advance.
Hi SteveG_91,
I would start this by removing the duplicate rows first and getting this table:
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:
Works for you? Mark this post as a solution if it does!
2 Replies
Hi SteveG_91,
I would start this by removing the duplicate rows first and getting this table:
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:
Works for you? Mark this post as a solution if it does!
Than worked Shaurya, thank you! Should have thought of that myself.
