Forum Discussion
Solved
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 ...
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.