Forum Discussion

Raj007's avatar
Raj007
Helper III
5 years ago
Solved

hi, really sorry if this very basic..summarize function

Hi, I am trying to use the summarize function but got stuck with the 3rd argument - it is not accepting the 3rd argument   1.trying to create a table using the summarize Customers_GropBy_Table=SUM...
General Comment
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    5 years ago

    Raj007 You need four arguments in your case. You have to name the field for the expression so like this:

     

    Customers_GropBy_Table=SUMMARIZE(

    'Sales SalesOrderDetail',
    'Sales SalesOrderDetail'[CustomerID],"Sales Amount",[Sales Amount])

     

    SUMMARIZE function (DAX) - DAX | Microsoft Docs

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Raj007 3rd argument, in your case, should be a Constant of a name you want to give for your expression like "My Sale Amount" and thereafter 4th argument is where you will give the actual formulae/expression/measure which is Sales SalesOrderDetail'[Sales Amount]