Forum Discussion
Dax to sum multiple rows within same table
I have a table with many rows of detail that I need to maintain, but I also need sum for multiple rows to generate ROI.
| Promotion # | Gross Sales | Gross Sales (Promo) |
| 123 | $100 | $300 |
| 123 | $200 | $300 |
| 124 | $50 | $50 |
I need dax to sum up the total of both lines of gross sales on promo 123 to the aggregate Gross Sales (Promo) line.
Help?
Hi, nj-matt
If you just want to sum values by group, please use formula as below:
measure/calculated column:
Gross Sales (Promo) = CALCULATE(SUM('Table'[Gross Sales]),ALLEXCEPT('Table','Table'[Promotion #]))Best Regards,
Community Support Team _ Eason
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 Replies
Hi, nj-matt
If you just want to sum values by group, please use formula as below:
measure/calculated column:
Gross Sales (Promo) = CALCULATE(SUM('Table'[Gross Sales]),ALLEXCEPT('Table','Table'[Promotion #]))Best Regards,
Community Support Team _ Eason
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
