TWO WAYS to group data in Power BI - SUMMARIZECOLUMNS, Group By // Beginners Guide to Power BI

Get Demo File here

In this video we go through the two different ways I use to group data explicitly in Power BI, either through DAX using the SUMMARIZECOLUMNS function or by using the Group By functionality in Power Query.

-

🚩 Support us to get perks such as demo files, early access and more!

MY FAVOURITE POWER BI BOOKS

MY GEAR

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

[bhainsley]

I have spent hours trying to get my DAX groupby function to work...you cleared it up in a few minutes. Thanks so much for sharing this. Keep up the good work.

[maksim]

groupby returns an error - multiple columns cannot converted to scalar value 😢😢

[jonathanvanderberg]

Useful video, thanks.

Question, I can't seem to find any information on what to do in terms of data modelling when you create for example a summarize\summarizecolumn table.

I want this table summarize table to link to my filters\dimensional tables that hold the attribute information so I can still use related filters that I would on my main fact\data table.

Should my summarize table be linked to each dimensional table itself?

Hope you shed some light on this for me. Thanks.

[chrislu]

great content . trying to use the function (after spliting the column) to solve the following problem but couldnt work it out .


Table1 that has a column " Option" has the following 3 rows of value: comma separated values

A, B, C
A, C
B, D

i want to be able to see the distinct value and count as below on the dashboard :
Option count
a, 2
b, 2
c, 2
d, 1

can you please shed some light on this

[CezW]

Great example, but it does not work for me. I have two data tables in a star schema: Instructors (Name, EmplID...) and Courses (CCode, CName, COrgUnitID...). I need find the count of courses per instructor. My data is: Instr1 CName1, Instr1 CName2, Instr1 CName3, Instr1 CName4, Instr2 CName5, Instr2 CName6, ... I want to get: Instr1 4, Instr2 2. Please help !

[tkin]

If I use the Groupby method and resulted with two tables, how will this affect my star schema in terms of how other dim_table reference?

[jayantmishra]

Hi...
Can you help me to solve this question ??

Which of the following DAX function will return a table :-

1 SUMMARIZECOLUMNS
2 CALCULATETABL
3 RELATEDTABLE
4 All of the above
5 None of the above

Please answer the question??

[ashishmohan]

Hi very useful video and very practical need everyone for every project big thanks to share with us.



If it can possible can you plzz provide us excel data file which you used.

Very greatful for us...👌👌👌👌👌👌👌👌💐💐💐💐🎂🎂🎂🎂🎂🎂🎂🎂🎂🎂🎂🎂

[aryansena]

Pls describe the difference between summerize, summarizecolumn, groupby