Skip to content
Home » SUMMARIZE Function DAX


The SUMMARIZE function is a Power Bi table manipulation function in DAX that allows you to create a customized table directly in Power BI, without using Power Query.

It returns a summary table for the requested totals over a set of groups.


SUMMARIZE(<table>,<groupBy_columnName>[,<groupBy_columnName>]…, name>,

<table> is a DAX expression that returns with a table of data.

<groupBy_columnName> is the qualified name of an existing column, which will be grouped based on the internal values.  This parameter cannot be an expression. It is an optional.

<name> is the name that is given to the new column that will total or summarise data. Each name must be enclosed in double quotation marks.

<expression> It may be any DAX expression that returns a single scalar value, which will be evaluated multiple times for each row, or context.

Here we have a sample dataset named as ITEM.


You can see the data of item table as given below.

Item         Color      Qty

Item A Silver 5
Item A Gold 10
Item C Silver 56
Item D Silver 15
Item C Red 289
Item E Gray 67
Item E Gold 40
Item A Gray 104
Item F Yellow 67
Item F Gray 96


Lets summarize the Item table data based total sum of quantity by color, Baiscally Summarize table will group the rows of Item table and returns the summarise table having a total sum of quantity by color.


Lets create a SUMMARZIE table , Go to Power Bi modeling header , click on Create a new table option as given below.


Now, write a following DAX that uses the summarize function Summarize_table and returns a table that holds the grouping of rows by color and total sum of quantity.

Summarize_table = SUMMARIZE(‘Item’, ‘Item'[Color], “Total Qty” , SUM(‘Item'[Qty]))


Once you commit the following DAX, It creates a Summarize table in Fields pane as you can see below.

Now you have a table that summaries the total quantity by color without using Power Query.

You can also validate the summarize data, Go to Data page.

Here you can see, How the summarize function groups the Item table records based on color.


Also Read..


SQL Basics TutorialSQL Advance TutorialSSRSInterview Q & A
SQL Create tableSQL Server Stored ProcedureCreate a New SSRS Project List Of SQL Server basics to Advance Level Interview Q & A
SQL ALTER TABLESQL Server MergeCreate a Shared Data Source in SSRSSQL Server Question & Answer Quiz
SQL DropSQL Server PivotCreate a SSRS Tabular Report / Detail Report
..... More.... More....More
Power BI TutorialAzure TutorialPython TutorialSQL Server Tips & Tricks
Download and Install Power BI DesktopCreate an Azure storage accountLearn Python & ML Step by stepEnable Dark theme in SQL Server Management studio
Connect Power BI to SQL ServerUpload files to Azure storage containerSQL Server Template Explorer
Create Report ToolTip Pages in Power BICreate Azure SQL Database ServerDisplaying line numbers in Query Editor Window


Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.