Differences between GROUPBY and SUMMARIZE

GROUPBY and SUMMARIZE seem similar, but they differ in both performance and functionalities. Choose the right one depending on specific scenarios!

[jambesh]

I would press 1K time like button if there is an option to do that. You explain the fundamental concept so beautifully with plenty of examples and the best part is "No irritating Commercial Ads" like other content creator do. You are the best !! Keep doing the great work !!!

[elrevesyelderecho]

0:00 - 1:28 Intro
1:29 SUMMARIZE
6:47 ADDCOLUMNS
11:25 GROUPBY
19:22 Conclusions
20:20 Final Exercise to compare both functions
27:42 Out

[yeyoremix]

I have found that the mix of groupby and summarise also comes really helpful when performing calculations over measures. For example finding the max result for a measure iterating over different groups of selected columns. This video will help me improve my calcs a lot!! Thank you!

[jimmyni]

Man! Really NO WORDS for this Master Piece! Kidding! Actually I DO HAVE... This is another GOLD Pill of wise! Bravo Bravo! Thank you so much again!

[mnowako]

Finally I have understood Groupby 😁
Thank you!

[rwjzodh]

Brilliant. So many takeaways. I'm going to scan some of my complex models and see if I can improve performance with this knowledge.
As always, SQLBI is a diamond.

[adrianoschwenkberg]

just wanted to say thank you for the efforts in making this free tutorial

[abhidhami]

This is really helpful ! Thanks for explaining Summarize and Group By with such detail.

[tamerjuma]

Brilliant and very insightful! Thank you Roberto for sharing your amazing knowledge.

[emilyamalkin]

This video is so helpful! A million thanks! Thank you Roberto, can’t wait to implement what I just learned! (it is especially helpful for me as a sql programmer, familiar with “group by”, but not with “summarize”, so I am really glad to learn the usage of both!)
❤

[brianligat]

I'd been transferring your example to the Adventure Works model I have, got an error, played a bit more only for your comment at 2:10 LOL. Another great tutorial. Thanks

[joaomarcoseliasmatias]

This is some gold content, Alberto. Your explanation videos give me motivation to dive into dax theory understanding.

Greetings from Brazil!

[analistax]

São videos como estes que você começa a assistir quando quer sair da simplicidade de uma linguagem. Entender tudo que está em volta do básico.

Perfeitamente, perfeito.
Muito obrigado.

[DriekWorks]

very good video; good explanation about the difference, and what not to dom and nicely working towards upper level optimisation thinking.

[alainluong]

In France, it is past midnight and I'm enjoying learning a lesson.... Are you coming from Pudlar? Cause you're Magic!

[ercipi]

It wouldn't hurt to smile on your Thumbnail Alberto :)

[mathew]

thank you for this video, an important one for sure

[eleftheriakoniari]

If I use this table to a table visual and have some slicers also, will be responsive to slicers? Do I need to make relationships? I tried it with summarizecolumns and didn't work and I couldn't create relationships also. Thank you so much! I have learned a lot from you!

[rajeevmenon]

Need some guidance. I have a table with 3 columns. Date, ID and amount. Amount contains both positive and negative amount datewise, idwise. If the sum of all id is positive, it is a debtor or else it is a creditor. A measure with IF condition is not going into a slicer to filter debtors apart from creditors. How do I do this ?

[Tom-kplv]

So at about 7:40 you have brand total and overall total. If I understood correctly, you said not to use that method. So what would be the best way to produce the same result, and how would you add % of total for each brand?