Forum Discussion
Summarize DAX
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
Seems like what you have is correct, are you getting an error?
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.
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