Reply
vincentakatoh
Helper IV
Helper IV

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])
)

2017-11-06 23_04_44-Untitled - Power BI Desktop.jpg

 

1 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

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

View solution in original post

8 REPLIES 8
avatar user
Anonymous
Not applicable

Im having problems to sum abs error values.

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

 

Capturar.PNG

Helen226
New Member

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
Super User
Super User

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...

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.



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...

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...

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

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

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.
avatar user

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

FebPBI_Carousel

Power BI Monthly Update - February 2025

Check out the February 2025 Power BI update to learn about new features.

Feb2025 NL Carousel

Fabric Community Update - February 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)