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

Подписаться 1,9 тыс.

Просмотров 20 тыс.

50% 1

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

Опубликовано:

2 окт 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 49

@namrathamalur403 Месяц назад

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

@HarshaVardhan-mx2lk 2 года назад

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

@dataexplained7305 2 года назад

Lol.. thank you 😊

@danthompson8309 2 года назад

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

@dataexplained7305 2 года назад

Point taken

@catalin.ardeleanu 2 года назад

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

@shitun1ify 2 года назад

@@dataexplained7305 to be a huge disappointment I

@mahithamylo66 6 месяцев назад

@@catalin.ardeleanu yes true

@ashishalex10 2 года назад

very informative, thanks for uploading !

@dataexplained7305 2 года назад

You welcome

@dp6736 Год назад

Very good explanation> Thank you very much.

@MrAammy 7 месяцев назад

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

@kennethstephani692 3 года назад

Great video. Very helpful!!

@dataexplained7305 3 года назад

Thank you...

@aashishsalotra6536 4 года назад

This is so helpful! Thanks!!

@dataexplained7305 4 года назад

You are very welcome...

@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?

@poojachoudhury2227 5 месяцев назад

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

@AndrehHimself 3 года назад

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 3 года назад

Appreciate that feedback. Stay tuned...

@aiinabox1260 2 года назад

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 2 года назад

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