cancel
Showing results for
Did you mean:

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Helper I

## sum total based on the value of another category.

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
1 ACCEPTED SOLUTION
Super User

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 🙂

Proud to be a Super User!

Super User

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 🙂

Proud to be a Super User!