Summarize DAX

[vincentakatoh]

Hi, 

Trying to create a new measure, TotalCount_Sum=39+2= 41. 

Me a DAX dummy, can advise what is wrong with below DAX?

TotalCount_Sum = SUMMARIZE(data2
	,Data2[3Station]
	,Data2[TotalCount],sum(Data2[TotalCount])
)

[Anonymous]

Im having problems to sum abs error values.

As you can see 2928 is wrong the correct accumulated sum should be 23.968

[Helen226]

Some might want one that features a detachable net blog post. Top rated Ping Pong Robot the first time you're mosting likely to do.

[Greg_Deckler]

You need a name for your column as parameter 4, just enclose it in double quotes.

[vincentakatoh]

Hi @Greg_Deckler

Can provide example, tried below but no success? Do I need to add as a Column or Measure?

TotalCount_Sum = SUMMARIZE(data2
	,Data2[3Station]
	,Data2[TotalCount]
,"TotalCount", sum(Data2[FailCount])
)

[Greg_Deckler]

I have this working for me:

Table = SUMMARIZE(Cars,Cars[Asset],Cars[Damage],"Sum",SUM(Cars[Column]))

Obviously different data set, but same thing.

[Greg_Deckler]

Seems like what you have is correct, are you getting an error?

[vincentakatoh]

hi @Greg_Deckler,

Yes, Error msg "the expression refers to multiple columns. Multiple columns cannot be converted to a scalar value". 

Also attached my sample file. If possible, appreciate if you can correct the dax and upload in link. 

https://1drv.ms/u/s!ArjVwEnHONXNggIZbMfBJHYsQK42

[v-shex-msft · Accepted solution]

Hi @vincentakatoh,

SUMMARIZE function will return a table as the result, it is impossible to store these result in calculated column or measure.

You need to summary these records and return the result.

For example:

TotalCount_Sum =
SUMX (
    SUMMARIZE (
        Data2,
        Data2[3Station],
        Data2[TotalCount],
        "TotalCount", SUM ( Data2[FailCount] )
    ),
    [TotalCount]
)

Reference:

SUMMARIZE Function (DAX)

Returns a summary table for the requested totals over a set of groups.

Notice: if your data contains any privacy data, please do mask sensitive data before sharing.

Regards,

Xiaoxin Sheng