SUMMARIZE - DAX Guide

SUMMARIZE: Creates a summary of the input table grouped by the specified columns.

This video is part of DAX Guide, the online guide to all the DAX functions, with links to related content and compatibility matrix with all the versions of Power BI, Azure Analysis Services (AAS), SQL Server Analysis Services (SSAS), SQL Server Data Tools (SSDT), and Power Pivot for Excel.


#dax #powerbi #ssas #tabular #analysisservices #powerpivot

[sunilkonatham]

Ur explanation is simple and any one can easily understand the concept, best teacher

[infosatish]

Addcolumn under Summarize was awesome, and this solves one of the requirements I had in my reports. Thanks! 😀

[giacofigueroa]

Sei sempre il top Alberto, a te e ai tuoi video (e anche ai libri) devo tanto di ciò che so e per questo ti ringrazio

[ahmedJaber]

Hi,
thank u for this.
I have been using pivot tables for a bit and they are time saving at times.
I have a database of projects their budgets and costs. I know that I can create custom subtotals and custom calculated columns, but was wondering if i could add a line underneath a subtotal to do a calculation e.g. i have one budget for the whole project but several categories of expenses. So I need to show the breakdown of expenses and at the end sum of it and then a new line showing the value of surplus or deficit.
Another thing I just noticed, if I added it to a data model to create a measure and check the variance, I am not able to choose custom subtotals

I would prefer to do it without VBA, but if it is a must, why not

[AUXA_]

Thank you for sharing. May I ask a question regarding your book " The Definitive Guide to Dax' 2nd edition. Page 370 regarding SUMMARIZE function. It works fine with your listed approach. However, if I break this one step into two separate two steps. Summarize first by literally creating a table, then AverageX. The result always gives me a SUM result. I can't figure out why? :-(

[meloshamefull]

which video can point me in a direction to create a list of measures as rows and column dates year then expand to months?

[davidtawa]

Great content and wonderfull explanation, thank you very much!!

[robrayborn]

I'm attempting to change the aggregation of the subtotal of my pivot table and though that this might be my answer. The subtotal currently provides the aggregation from this DAX formula: Price:=IF(OR([Part Qty]=0, [Part Qty PY]=0), 0, ([Avg LE Price]-[PY Avg LE Price])*[Part Qty]). I need the subtotal to produce the sum of this formula. Any suggestions?

[mueez]

Hi Alberto,

You explained somewhere that we avoid adding columns to summarize since it creates both a filter context and a row context. Can you please explain how can this potentially be dangerous? And in what circumstances would this produce incorrect computations?

[eziola]

You mention in the video that you recommend NOT using SUMMARIZE() to add columns due to the ambiguity of the row and filter context being applied at the same time and instead using ADDCOLUMNS() in conjunction with SUMMARIZE(). That makes sense. My question is this:
Is it more commone to do an ADDCOLUMNS ( SUMMARIZE ( ) ) or a SUMMARIZE ( ADDCOLUMNS ( ) )? Is there a video or explanation on which usage is most common?

[vijayS]

Hi it's giving me error
Sumr = SUMMARIZE(FactOrder, DimCustomer[City], "City Total", SUM(FactOrder[Sales]))
what i missed, please help

[Boomboompowwow]

why not show a working example in power bi fool