cancel
Showing results for
Did you mean:
Frequent 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
Community Support Team

## 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
Community Support Team

## 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.
Highlighted
Frequent 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