Forum Discussion

Tomo2709's avatar
Tomo2709
Regular Visitor
7 years ago
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 >...
Need Help
  • v-danhe-msft's avatar
    v-danhe-msft
    7 years ago

    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

     

     

v-danhe-msft's avatar
v-danhe-msft
Microsoft Employee
7 years ago

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's avatar
    Tomo2709
    Regular Visitor
    7 years ago

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

     

    Paul