DAX Fridays! #145: SUMMARIZECOLUMS

In today's #daxfridays we will cover the DAX function SUMMARIZECOLUMNS and compare it to SUMMARIZE.

SUBSCRIBE to learn more about Power and Excel BI!

☼☼☼☼☼☼☼☼☼☼

POWER BI COURSES:

Want to learn Power BI? How about you take one of our courses? Here you can find the available courses:

☼☼☼☼☼☼☼☼☼☼

ABOUT CURBAL:

▼▼▼▼▼▼▼▼▼▼

If you feel that any of the videos, downloads, blog posts that I have created have been useful to you and you want to help me keep on going, here you can do a small donation to support my work and keep the channel running:

▲▲▲▲▲▲▲▲▲▲

Our PLAYLISTS:

************

************

QUESTIONS? COMMENTS? SUGGESTIONS? You’ll find me here:
Twitter ► @curbalen, @ruthpozuelo

#daxfridays #curbal #SUBSCRIBE

[workstuff]

I love your excitement and energy in your videos 👍

[danielsiffredi]

Ruth, you are an angel! you just taught me how to get done something that I was munching for DAYS... thank you SO MUCH!

[benhalicki]

I love your comment about Microsoft documentation and 'words i cannot understand'. I thought it was just me! Great videos, keep them coming :)

[AArora]

That little dance from 3:33 to 3:38 was cute :-). Always great to have an opportunity to enjoy what one does as work. That said, thanks for all your useful videos all these years!

[Henrik.Vestergaard]

Hi Ruth. At 8:00 you show the use of SUMMARIZECOLUMNS in measures. I can make it work in a simple measure, but what do you make of this from sqlbi: "SUMMARIZECOLUMNS cannot be used if the filter context contains a row context or a filter context generated by context transition or an arbitrarily shaped set. This limitation makes it unusable in any measure. It is a function intended solely for queries and calculated tables." Regards, Henrik

[joseagundis]

Gracias Ruth, como siempre EXCELENTES tus videos, además eres de los pocos MVP que leen y responden los comentarios, un plus más. Saludos

[jacquelinelacan]

Ruth! First of all, thank you for these top quality videos! But, I insist on saying that you're lovely! Tack så mycket!

[vasistakumar]

Ruth, fantastic work...thank a lot for your explanation...master of the DAX..

[joelngige]

Thanks for the wonderful explanation on summurazecolumns using several examples. Really appreciate.

[Pepe]

I don't know why I don't use this measure more often!!! you're the gratest!!!

[graemegourlay]

Excellent content. Just used it for a Microsoft Customer Voice report to be able to filter responses when the filter content is one of the questions in a survey: Created a table from the DAX and added it into the data model. Took a bit of thinking to figure it out and test. Code below shows how to use the FILTER and RELATED functions.

Activities =
SUMMARIZECOLUMNS(
msfp_questionresponse[msfp_surveyresponseid],
msfp_questionresponse[Response],
FILTER(msfp_questionresponse, RELATED(msfp_questions[Question]) = "Client")
)

[dasrotrad]

I have seen the magic! Summarize and Summarizecolumns .. totally kill it! I'm putting this to use today. You rock Ruth. Thank you!!

[MrAszpic]

Best practices videos are always welcome, thanks and I'll be waiting for the next Friday vid!

[EricaDyson]

Ditto Ruth. Have logged these in my " Must Use" list! Thanks a lot. Have a great weekend yourself.

[marcobaquero]

Hi Ruth so clear, as always...!!! Tks!!

[samuelmanseau]

It's always a chance to find a way to improve! Thanks & thanks for your enthousiasme !

[ayobamiologun]

Another interesting exposition from you... Thank you Ruth.

[davidcadman]

Great stuff. I use it all the time to query our Analysis Services model. It's much easier because we have multiple fact tables and often need to include measures aggregated from more than one of them. Summarize (and with Addcolumns) does include rows where the measure / all measures are blank.

[dex]

Great video! Well explained. I have question though, and I'm not sure the best way to accomplish this, but I have data set that contains a series of categorical information in a in a column (vertically), and the associated date with those categories displayed within a row (horizontally). Is there a way to pull the associated values in both those arrays and perform calculations, without having them vertically aligned?

Let me know if this makes sense.
Thank you!

[naveen]

Hi curbal, how can i get a pivot or matrix like view in this dax output. Where i can see category revenue for each year in a seperate column. Instead all years in one column.