Multiple summarised columns in calculated table

[Tomo2709]

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 

[v-danhe-msft · Accepted solution]

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])  
      ) 

in below link:

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

Regards,

Daniel He

[Tomo2709]

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

Paul