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
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.
Solved! Go to Solution.
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.
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!
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
107 | |
96 | |
92 | |
87 | |
69 |
User | Count |
---|---|
165 | |
130 | |
129 | |
102 | |
98 |