GROUP your data using SUMMARIZE DAX Function in Power BI // DAX Basics for Beginners in 2022

Get Demo Files here

In this video were going to cover how you can use the SUMMARIZE function to group data in DAX very easily. Were going to also cover a few elements you can combine with SUMMARIZE such as ROLLUP and ISSUBTOTAL

SUMMARIZE Documentation

-

🚩 Get Demo Files here

👍 Become a Patreon to support the channel and get free perks!

🛍 Get exclusive templates built using best practices here

❤ Other ways to support

GET IN TOUCH

🌍 WHO IS SOLUTIONS ABROAD
Hi, my name is Fernan, the one-man band of Solutions Abroad. I work as a Data Scientist based in London, UK and have over 6 years of experience working in Business Intelligence. Solutions Abroad these days is dedicated to teaching the ins and outs of Power BI, through the power of YouTube.

If you want to learn more, I’ve conveniently created playlists to help you find the right topic for you.

🐎 First, watch this video about how a typical Power BI workflow looks like

🗺 Learn DAX to extend your Power BI calculations

📆 Stay up-to-date on all the features Power BI releases monthly

🧪 Get certified as a Microsoft Data Analyst Associate

💡 Learn Power BI Features to improve your dashboards

📊 WHAT IS POWER BI?
Power BI is a business analytics tool by Microsoft. It creates a working environment suited for normal users, meaning tasks such as data extraction, cleansing, analysis and storytelling; these are made easily-accessible to citizen-users, and extendable for technical users. At face value it provides visually-stunning, interactive dashboards, but it’s built on top of so much more.

🔻 Get started with Power BI Desktop for FREE

#PowerBI #DataAnalytics #BusinessIntelligence

[kvhuqez]

This guy is the best PowerBI Channel for learning powrBI

[datawhipper]

Thanks for sharing, learnt two new functions(ROLLUP & ISSUBTOTAL).

[veebee]

Thank you Sir. Clear and methodical expressions with the right amount of details.

[davidgitau]

Very good explanation. Include performance comparison commentaries.

[Devloper]

Great Explanation Brother!!!! Those who watch the video they should at least like the video!

[gintomino]

Keep em coming! I’m learning a lot from your channel. Thanks for sharing!

[sopauljauck]

Thanks for the vid as always. I sub because I have benefitted from your other vids. Question. How would you pull in another aggregate on another measure living in a different table? Can you include that in the same summarize?

[danielrusinski]

Wow. Really great material. Well explained. Thank you Sir!

[padynz]

Really appreciate this Excellent video with a lucid explanation🧡

[sbb]

I'm on the newest version of PowerBi, I dragged Region Name and Sales Volume into my table, but its not summarizing the data, its listing the region over and over and over with the volume next to each row.?? I don't have the Sum or Average options.

[SiddhantGode-rh]

How do we do the same from two different tables??

[rahulkumarbhagat]

hi Fernan,
i am in situation like i am having 10 paginated report in my premium workspace and each report having its user access list . How can we restrict user to access others reports to see in APPS? Please help me

[mainuser]

i grouped my values by year and month, but they appear as text value.. i cant convert it to date. any idea?

[petecardona]

So what’s the point of summarize. You just can do everything with just the basic report view by checking the required criteria. Please explain? I see a lot of measures not very useful as they pretty much do the same as the report view stuff.

[haltertv]

I think he does not know too much about data modeling and DAX: A 3NF data model instead of star schema… Teaching implicit measures instead of (only) explicit measures… then I stopped after 2 minutes…