Summarize() vs AddColumns() vs SummarizeColumns() Which of these has the best performance & how ?
HTML-код
- Опубликовано: 7 июл 2020
- In this video we will discuss about the best DAX formula for summarizing a table. We will see how each of these formulas are derived and their respective performances using DAX Studio and finally we will use one of these in a DAX measure as a variable.
Always clear cache before loading data in DAX studio !! 
Наука
You explained everything so easy because you undertand it in depth!
Thanks man! This video helped be a lot!
You are welcome..
Just what I needed to learn at this time in my learning curve. Thank you! Other comments were helpful, too, Good stuff.
You are welcome my friend.. stay tuned for more..
Superb Explanation Buddy.... great content... Keep grinding
Lol.. thank you 😊
Very good explanation> Thank you very much.
This is so helpful! Thanks!!
You are very welcome...
very informative, thanks for uploading !
You welcome
Great video. Very helpful!!
Thank you...
Tnq for this video, I was clearly explained
This kind of explanation is required to understand Dax. Keep doing more video s
Thanx.. will do
Gracias! Muy buen video!
Thank you....
Btw good job, bro....Fe , se comparison is a real eye opener
Thanks
Appreciate the video, good discussion of table functions. I would suggest clearing the cache between queries to get true insights.
Point taken
@@dataexplained7305 maybe you could give up the annoying mouse click sound... from last century. Otherwise, I appreciate very much your work :)
@@dataexplained7305 to be a huge disappointment I
@@catalin.ardeleanu yes true
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
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.
Appreciate that feedback. Stay tuned...
Superb video Mate, thanks for sharing.... can you please provide the datasource for this?
I used the adventure works datawarehouse database from Microsoft.. download any version.. they all have same structure
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?
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
Can you skip the video to 12 th minute..let me.know if it helps..
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
So, is add columns and summarize pattern better than summarize in performance ?
Thanks for your comment and you're correct...
One query: Can the columns come from different tables? Could you clarify, please?
Absolutely, as far as those tables are related(connected), you can use columns from the model..
@@dataexplained7305 Awesome..!! Thank you...
How can i contact please help i am in crisis
Could you please write your queries to dataandyou@gmail.com
Thr videoa s good... But those clicks are killing
Thanx. there is always a scope of improvement.. 😊
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 😂😂
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..