cancel
Showing results for
Did you mean:
Regular Visitor

## Multiple summarised columns in calculated table

Hi

I have created a calculated table with the following DAX formulae:

DURATION SUMMARISED = SUMMARIZE('Sheet1','Sheet1'[Matter > Short Matter Name],Sheet1[Matter > Matter ID],Sheet1[Matter > Description],"Units Summarised",SUM(Sheet1[Matter > Duration (Actual)]))

The summarise function provides me with unique data for Sheet1'[Matter > Short Matter Name] and Sheet1[Matter > Matter ID],Sheet1[Matter > Description] and the sum function proides me with aggregated values for the matter duration (Sheet1[Matter > Duration (Actual)).

I wondered if there was a way to have two "sum" columns i.e. by adding another sum(....) at the end of the formulae?  I did try and also tried "sumx" but nothing worked - any help/guidance appreciated.

Many thanks

Paul
1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Microsoft

## Re: Multiple summarised columns in calculated table

Hi @Tomo2709,

From your description, the SUMMARIZE function could do multiple sum in a formula, you could refer to the example code

```SUMMARIZE(ResellerSales_USD
, DateTime[CalendarYear]
, ProductCategory[ProductCategoryName]
, "Sales Amount (USD)", SUM(ResellerSales_USD[SalesAmount_USD])
, "Discount Amount (USD)", SUM(ResellerSales_USD[DiscountAmount])
) ```

https://docs.microsoft.com/en-us/dax/summarize-function-dax

Regards,

Daniel He

Community Support Team _ Daniel He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 REPLIES 2
Highlighted
Microsoft

## Re: Multiple summarised columns in calculated table

Hi @Tomo2709,

From your description, the SUMMARIZE function could do multiple sum in a formula, you could refer to the example code

```SUMMARIZE(ResellerSales_USD
, DateTime[CalendarYear]
, ProductCategory[ProductCategoryName]
, "Sales Amount (USD)", SUM(ResellerSales_USD[SalesAmount_USD])
, "Discount Amount (USD)", SUM(ResellerSales_USD[DiscountAmount])
) ```

https://docs.microsoft.com/en-us/dax/summarize-function-dax

Regards,

Daniel He

Community Support Team _ Daniel He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Regular Visitor

## Re: Multiple summarised columns in calculated table

I forgot to name the column for the second sum function thank you for your help.  Works perfectly.

Paul

Announcements

#### Announcing the New Spanish Forum

Do you need help in Spanish? Check out our new Spanish community section.

#### April 2020 Community Highlights

Info on our Super Users, MBAS content and badges, and updates to our support articles. - Read the full Community Highlights.

#### MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.

Top Solution Authors
Top Kudoed Authors