cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Tomo2709 Frequent Visitor
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
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])  
      ) 

in below link:

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

in below link:

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
Tomo2709 Frequent Visitor
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