Dax to sum multiple rows within same table

[nj-matt]

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?

[v-easonf-msft · Accepted solution]

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.

[jaipal]

@nj-matt try this 

Measure = SUMX(VALUES('Table'[Promotion]), CALCULATE(SUM('Table'[Gross sales (Promo)])))