Forum Discussion
Solved
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
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
2 Replies
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
I forgot to name the column for the second sum function thank you for your help. Works perfectly.
Paul
