sum total based on the value of another category.

[dwhittaker1]

I would like to create a measure that calculates the total sum of all payments based on the site showing in that row. So for example, the new calculated column would return 15 in row 1 because  the total payment for ATL is 15 ( row  1+ row 3) .The 2nd row in the calculated column would return 50 because that is the total payment for NYC ( row 2 + row 5)

Site	Segment	Order #	Order line	payment
ATL	White	1	A	10
NYC	Brown	1	B	20
ATL	Yellow	2	A	5
MD	Yellow	2	B	10
NYC	Green	3	A	30

Expexted Out Put

Site	Segment	Order #	Order # line	payment	New Column
ATL	White	1	A	10	15
NYC	Brown	1	B	20	50
ATL	Yellow	2	A	5	15
MD	Yellow	2	B	10	10
NYC	Green	3	A	30	50

[ray_aramburo · Accepted solution]

Create a Measure/New Column with the following DAX:

Payments_Sum = CALCULATE(SUM('Table'[payment]), ALLEXCEPT('Table','Table'[Site]))

 I attached you an example with the dummy data you provided 🙂