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

Great explanation, thank you.

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.

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?

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

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

Thank you so much for this.

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

wow thank's

Thank you so much!

Good Video!

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.

Pls describe the difference between summerize,summarizecolumn,groupby

👍

Hi very useful video and very practical need everyone for every project ......very 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...👌👌👌👌👌👌👌👌💐💐💐💐🎂🎂🎂🎂🎂🎂🎂🎂🎂🎂🎂🎂