Differences between GROUPBY and SUMMARIZE

  Рет қаралды 32,116

SQLBI

SQLBI

9 ай бұрын

GROUPBY and SUMMARIZE seem similar, but they differ in both performance and functionalities. Choose the right one depending on specific scenarios!
Article and download: sql.bi/805881?aff=yt
How to learn DAX: www.sqlbi.com/guides/dax/?aff=yt
The definitive guide to DAX: www.sqlbi.com/books/the-defin...

Пікірлер: 43
@mnowako
@mnowako Ай бұрын
Finally I have understood Groupby 😁 Thank you!
@elrevesyelderecho
@elrevesyelderecho 9 ай бұрын
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
@yeyoremix 9 ай бұрын
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!
@jimmy3862
@jimmy3862 2 ай бұрын
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!
@emilyamalkin4367
@emilyamalkin4367 9 ай бұрын
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!) ❤
@tamerjuma
@tamerjuma 9 ай бұрын
Brilliant and very insightful! Thank you Roberto for sharing your amazing knowledge.
@adrianoschwenkberg6773
@adrianoschwenkberg6773 9 ай бұрын
just wanted to say thank you for the efforts in making this free tutorial
@joaomarcoseliasmatias9156
@joaomarcoseliasmatias9156 8 ай бұрын
This is some gold content, Alberto. Your explanation videos give me motivation to dive into dax theory understanding. Greetings from Brazil!
@user-rw5jz8od7h
@user-rw5jz8od7h 9 ай бұрын
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.
@abhi007dhami
@abhi007dhami Ай бұрын
This is really helpful ! Thanks for explaining Summarize and Group By with such detail.
@analistax
@analistax 9 ай бұрын
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.
@Bharath_PBI
@Bharath_PBI 9 ай бұрын
As always great content! 👍 Thank you.
@brianligat9493
@brianligat9493 6 ай бұрын
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
@DriekWorks
@DriekWorks 9 ай бұрын
very good video; good explanation about the difference, and what not to dom and nicely working towards upper level optimisation thinking.
@mathew9665
@mathew9665 9 ай бұрын
thank you for this video, an important one for sure
@siddheshamrutkar8684
@siddheshamrutkar8684 2 ай бұрын
Fantastic Video.
@ercipineda1357
@ercipineda1357 9 ай бұрын
It wouldn't hurt to smile on your Thumbnail Alberto :)
@MrAstonmartin78
@MrAstonmartin78 2 ай бұрын
Brilliant Video. Thanks
@Piece101
@Piece101 9 ай бұрын
Golden tutorial 👌🏼
@g.oliveira1184
@g.oliveira1184 9 ай бұрын
Parabéns! Amei a explicação.
@alainluong3305
@alainluong3305 9 ай бұрын
In France, it is past midnight and I'm enjoying learning a lesson.... Are you coming from Pudlar? Cause you're Magic!
@vishiousvish2832
@vishiousvish2832 9 ай бұрын
Thx for this leason !!!
@Tom-kp2lv
@Tom-kp2lv 9 ай бұрын
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?
@rajeevmenon1975
@rajeevmenon1975 9 ай бұрын
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 ?
@lovlyhearts288
@lovlyhearts288 9 ай бұрын
I am having one doubt but not related to this content, Using teatedas Dax I connected date table and fact table. When user want to drill fact table aggregation value it's not filter date table untill I drag & make active relationship in the model, Is any other alternative way there to achieve this ?
@victorrivas7911
@victorrivas7911 9 ай бұрын
Sorry but I don't see the difference between the "Transaction Size" local column in 10:35 and the local table with "A" and "B" as local columns in 18:41. Both of the cases are columns calculated on-the-fly, however, in the first case SUMMARIZE() works, and in second it doesn't. Is this happening because of the Lineage as you say in 18:48?
@chaitanyalanka7043
@chaitanyalanka7043 8 ай бұрын
Hi can you help me with this (I have two dates like service date and post date if we select service date the data related to service date has to show if change the date to post date the data has to show by post date in the same page in power bi is it possible?)
@mazenalali7810
@mazenalali7810 9 ай бұрын
great video
@nikakalichava8012
@nikakalichava8012 9 ай бұрын
amazing !
@dutch-man
@dutch-man 9 ай бұрын
At 26:55 SUMX is used whereas we really are performing a SUM of the column [@Sales]; is this done solely because we need to be able to add the CURRENTGROUP() as a table reference? Thanks
@SQLBI
@SQLBI 9 ай бұрын
Yes
@pbihari0214
@pbihari0214 9 ай бұрын
thank you
@guochuqiao
@guochuqiao 8 ай бұрын
Genius ❤
@angelgarciadatablog
@angelgarciadatablog 9 ай бұрын
Thanks to share, I have a question, whats the difference between local column and model column?
@angelgarciadatablog
@angelgarciadatablog 9 ай бұрын
I think that I understand the different: Local column is a column that was created by dax, and Model column is a column that belongs to principal table. Please, I apreeciate if you could confirm. Thanks.
@SQLBI
@SQLBI 9 ай бұрын
Confirmed!
@vijayvizzu1
@vijayvizzu1 9 ай бұрын
Hi could you please explain, what is local column vs model column
@SQLBI
@SQLBI 9 ай бұрын
Local column is created in a dax variable, model column is defined in the table (calculated columns are model columns).
@vijayvizzu1
@vijayvizzu1 9 ай бұрын
@@SQLBI Thank you 👍
@defaultHandle1110
@defaultHandle1110 9 ай бұрын
We need an ai to translate his Italian hand gestures to visualisations and animations.
@Negi_From_Pauri
@Negi_From_Pauri 9 ай бұрын
Sometimes you look like EMINEM
Understanding context transition
18:25
SQLBI
Рет қаралды 62 М.
Black Magic 🪄 by Petkit Pura Max #cat #cats
00:38
Sonyakisa8 TT
Рет қаралды 37 МЛН
Шокирующая Речь Выпускника 😳📽️@CarrolltonTexas
00:43
Глеб Рандалайнен
Рет қаралды 11 МЛН
ONE MORE SUBSCRIBER FOR 6 MILLION!
00:38
Horror Skunx
Рет қаралды 15 МЛН
GROUP BY in Power BI Query Editor - Do you need all that detail?
6:20
How to Power BI
Рет қаралды 24 М.
Using join functions in DAX
40:30
SQLBI
Рет қаралды 10 М.
Solving errors in CALCULATE filter arguments
30:55
SQLBI
Рет қаралды 26 М.
When to use KEEPFILTERS over iterators
18:56
SQLBI
Рет қаралды 46 М.
3 Ways to use Calculation Groups You Need to Know
20:00
How to Power BI
Рет қаралды 52 М.
Filter Context in DAX
16:03
SQLBI
Рет қаралды 66 М.
Using ALLEXCEPT vs ALL VALUES
13:35
SQLBI
Рет қаралды 51 М.
Analyzing a slow report query in DAX Studio
10:33
SQLBI
Рет қаралды 38 М.
ПРОБЛЕМА МЕХАНИЧЕСКИХ КЛАВИАТУР!🤬
0:59
Корнеич
Рет қаралды 3,7 МЛН
ПК с Авито за 3000р
0:58
ЖЕЛЕЗНЫЙ КОРОЛЬ
Рет қаралды 1,8 МЛН