Summarize() vs AddColumns() vs SummarizeColumns() Which of these has the best performance & how ?

[@Nmmalur403]

This video is brilliant! Could you please make more tutorials on DAX and analyzing performance implications using DAX Studio?

[@Andres_El_Paisa]

You explained everything so easy because you undertand it in depth!
Thanks man! This video helped be a lot!

[@dataexplained7305]

You are welcome..

[@HarshaVardhan-mx2lk]

Superb Explanation Buddy.... great content... Keep grinding

[@dataexplained7305]

Lol.. thank you 😊

[@sharathkumar1103]

Tnq for this video, I was clearly explained
This kind of explanation is required to understand Dax. Keep doing more video s

[@dataexplained7305]

Thanx.. will do

[@MrAammy]

Thanks for the explaining the difference. I have sued the summarised function in the same way you used but my grand total is not correct ? Any guidance would really help

[@endgamexpert]

Just what I needed to learn at this time in my learning curve. Thank you! Other comments were helpful, too, Good stuff.

[@dataexplained7305]

You are welcome my friend.. stay tuned for more..

[@dp6736]

Very good explanation> Thank you very much.

[@danthompson8309]

Appreciate the video, good discussion of table functions. I would suggest clearing the cache between queries to get true insights.

[@dataexplained7305]

Point taken

[@catalin.ardeleanu]

@@dataexplained7305 maybe you could give up the annoying mouse click sound... from last century. Otherwise, I appreciate very much your work :)

[@shitun1ify]

@@dataexplained7305 to be a huge disappointment I

[@mahithamylo66]

@@catalin.ardeleanu yes true

[@priyajuneja178]

Superb video Mate, thanks for sharing.... can you please provide the datasource for this?

[@dataexplained7305]

I used the adventure works datawarehouse database from Microsoft.. download any version.. they all have same structure

[@poojachoudhury2227]

Nice info. But I am stuck in one of my development where I am using summarizecolumn in a measure but the total value is incorrect ..
Can you help me with that

[@AyihSitti]

Hey Senthil, I n getting this error message when I try any of the functions "The expression refers to multiple columns. Multiple columns cannot be converted to a scalar value.". I m using the same database. Any suggestion please?

[@ashishalex10]

very informative, thanks for uploading !

[@dataexplained7305]

You welcome

[@aiinabox1260]

Btw good job, bro....Fe , se comparison is a real eye opener

[@dataexplained7305]

Thanks

[@kennethstephani692]

Great video. Very helpful!!

[@dataexplained7305]

Thank you...

[@AndrehHimself]

Great content, the only thing I would recommend changing would be disabling those mouse click sounds and bell ring, they're quite annoying.
Thumbs up anyway.

[@dataexplained7305]

Appreciate that feedback. Stay tuned...

[@aashishsalotra6536]

This is so helpful! Thanks!!

[@dataexplained7305]

You are very welcome...

[@karthikpillai520]

HI Good video, may I know how to see the select sql in the DAX studio. i see other measures but not this one. thanks

[@dataexplained7305]

Can you skip the video to 12 th minute..let me.know if it helps..

[@divyasukumar7324]

So, is add columns and summarize pattern better than summarize in performance ?

[@dataexplained7305]

Thanks for your comment and you're correct...

[@ajieapen]

One query: Can the columns come from different tables? Could you clarify, please?

[@dataexplained7305]

Absolutely, as far as those tables are related(connected), you can use columns from the model..

[@ajieapen]

@@dataexplained7305 Awesome..!! Thank you...

[@aperez1969]

Gracias! Muy buen video!

[@dataexplained7305]

Thank you....

[@hiteshjoshi3148]

How can i contact please help i am in crisis

[@dataexplained7305]

Could you please write your queries to [e-mail]

[@anz672]

Very useful

[@KirillBezzubkine]

Thr videoa s good... But those clicks are killing

[@dataexplained7305]

Thanx. there is always a scope of improvement.. 😊

[@aiinabox1260]

Why the hell should I use addcolumns & use calculate instead of summarize ?? What differentiation does this addcolumns brings to the table. Of the 3 summarizecoulmns outperforms then y we need to learn or use summarize, addcolumns ??? Marketing gimmicks to say pbi has 500+ builtins 😂😂

[@dataexplained7305]

There are specific use cases for each.. this one in video is a very common use case.. but you may be right too.. never know..