cancel
Showing results for
Did you mean:

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

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!

Announcements

#### Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

#### Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

#### Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors