- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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]) )
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
If this post helps, please consider accept as solution to help other members find it more quickly.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Im having problems to sum abs error values.
As you can see 2928 is wrong the correct accumulated sum should be 23.968
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
You need a name for your column as parameter 4, just enclose it in double quotes.
Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!: Power BI Cookbook Third Edition (Color)
DAX is easy, CALCULATE makes DAX hard...
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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]) )
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I have this working for me:
Table = SUMMARIZE(Cars,Cars[Asset],Cars[Damage],"Sum",SUM(Cars[Column]))
Obviously different data set, but same thing.
Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!: Power BI Cookbook Third Edition (Color)
DAX is easy, CALCULATE makes DAX hard...
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Seems like what you have is correct, are you getting an error?
Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!: Power BI Cookbook Third Edition (Color)
DAX is easy, CALCULATE makes DAX hard...
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
If this post helps, please consider accept as solution to help other members find it more quickly.

Helpful resources
Join us at the Microsoft Fabric Community Conference
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Power BI Monthly Update - February 2025
Check out the February 2025 Power BI update to learn about new features.

Subject | Author | Posted | |
---|---|---|---|
08-09-2024 01:42 AM | |||
04-04-2024 02:27 PM | |||
01-28-2025 12:40 AM | |||
01-28-2025 03:52 AM | |||
09-14-2024 02:00 PM |
User | Count |
---|---|
86 | |
79 | |
42 | |
40 | |
35 |