How to Use SUMMARIZE in DAX

How to Use SUMMARIZE in DAX//
In this lesson, I'm going to show you how to use the SUMMARIZE function in DAX.
0:24 Agenda
0:44 Summarize
1:43 ROLLUP with Summarize
2:14 Case
Content Link: drive.google.com/file/d/1AbXV...
___________
Highly recommended Power BI books (Affiliate links):
***The Definitive Guide to DAX: Business Intelligence for Microsoft Power BI, SQL Server Analysis Services, and Excel Second Edition: amzn.to/3ldPLpk
***DAX Patterns (Second Edition): amzn.to/3fBKdnD
***Analyzing Data with Power BI and Power Pivot for Excel: amzn.to/3fDPLOd
***Beginning DAX with Power BI: amzn.to/3fDEe1k
***Storytelling with Data: A Data Visualization Guide for Business Professionals: amzn.to/3mfPcwE
***Storytelling with Data: Let's Practice!: amzn.to/36c6Cot
***Information Dashboard Design: amzn.to/2V61o7h
___________Relevant PBI Topics
- MEASURES vs CALCULATED COLUMNS in DAX: • MEASURES vs CALCULATED...
- How to Use the ALL DAX Function in Power BI: • How to Use the ALL DAX...
- How to Use the Filter DAX Function in Power BI [The Basics]: • How to Use the Filter ...
- How to Calculate PERCENTAGES in Power BI: • How to Calculate PERCE...
- How to COMBINE Tables in Power BI: • How to COMBINE Tables ...
____________
[DISCLAIMER]: Some links included in this description might be affiliate links. If you purchase a product with those links, I might receive a small commission. However, there is no additional charge to you! I appreciate your support and this will help me provide you with free content on a weekly basis.
If you like the content, feel free to buy me a cup of coffee 😀👇www.paypal.me/quipuanalytics
If you don't want to miss anything, subscribe to our newsletter: vizxlization.com/welcome-to-v...
___________Please follow us on:
Web: www.quipuanalytics.com/
LinkedIn: / quipuanalytics
Twitter: / quipuanalytics
Facebook: / quipuanalytics
Instagram: / nestoradrianzen
Leave your comments and questions below!
Don't forget to subscribe!
Thanks so much!
#Summarize #DAX #vizxlization

[@michafabich9213]

love your tutorials, you have really approachable way of explaining complicated stuff

[@NestorAdrianzen]

Glad to hear that!

[@IvanCortinas_ES]

Super video Nestor. Thank you for explaining it in such a detailed way.

[@NestorAdrianzen]

Thanks for your feedback, Iván! Keep up the great work 👊

[@spilledgraphics]

Loving the 💥💣BOOMS 💣💥 ! awesome video Nestor ! 👌👌

[@NestorAdrianzen]

Glad you found the content helpful, Carlos! Boom!💥 💥💥

[@juanignacioXI]

Smooth, ty Nestor!

[@NestorAdrianzen]

I appreciate your feedback, Juan. Keep up the great work!👊

[@TheAliLeba]

Thank you for an excellent tutorial!

[@NestorAdrianzen]

Awesome. Glad you found the content helpful! 👍

[@beytullahozdemir172]

I’m learning a lot from this!

[@NestorAdrianzen]

Glad to hear that!

[@kennethstephani692]

Great video!

[@NestorAdrianzen]

Kenneth, Thanks for stopping by and keep up the great work! 👍

[@Phoenixspin]

Excellent!

[@NestorAdrianzen]

Thanks for your support, Phoenixspin!

[@mohdmuzammil3059]

Thanks you really helpful

[@NestorAdrianzen]

Mohd, Glad you found the content helpful. Cheers!

[@ALPHERATZ3650]

Muy buena explicación

[@NestorAdrianzen]

Glad you found it helpful!

[@sophyrath9299]

but why do we need to create another table (or using Summarize function) ? we can find the same number from the original table?

[@NestorAdrianzen]

Sophy Rath, Good question. Yes, you can use the original table as well. Personally, I like to use Summarize to create table expressions that are part of other DAX functions such as CALCULATETABLE.

[@krishnakanth8708]

Hi Nestor..!!
Thank you for posting the amazing stuff.
Just a small suggestion, while solving the case , please do mention the question once again on the screen.
Hope you got me and Cheers.....!!!!

[@NestorAdrianzen]

Krishna,
Thanks for your feedback. I'll keep this in mind for my next tutorials!

[@Mustapha_d]

Merci

[@NestorAdrianzen]

Keep up the great work, Codm44 Data!👍

[@monsieurashishk]

excellent video as always Nestor. However I don't think this is the perfect use case of summarize function. you can achieve the same result without summarize by using just a table or matrix . Summarize function will be helpful in a case where we get the duplicates in rows ( like an example shared by Ruth on her channel called Curbal on youtube)

[@aiinabox1260]

Too many functions too much of confusion in power bi. The same thing can be achieved with matrix without summarize , pl correct me if am wrong

[@NestorAdrianzen]

Raja,
Thanks for stopping by. Yeah, DAX can sometimes be overwhelming. I usually use SUMMARIZE to create virtual tables. Virtual tables are table expressions embedded in more complex calculations. Virtual tables give you more flexibility to play with the data. If you want learn more about virtual tables, you might want to check this video. Cheers! czcams.com/video/GH3prQ0GLkQ/video.html