Forum Discussion
Summarize DAX
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]) )
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:
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
8 Replies
You need a name for your column as parameter 4, just enclose it in double quotes.
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]) )
I have this working for me:
Table = SUMMARIZE(Cars,Cars[Asset],Cars[Damage],"Sum",SUM(Cars[Column]))
Obviously different data set, but same thing.
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.
