• Skip to main content
  • Skip to footer

Curbal

Learn how to grow your business with your data and Power BI

  • Data Stories
    • Power BI Stories
    • 1 dataset, 100 matplotlib visualizations
  • Learning Portal
    • Download Center
    • 25 Days Challenge
    • DAX Glossary
    • Power BI
    • Power BI by Topic
    • Python
    • 1 dataset, 100 matplotlib visualizations
  • Courses
    • Power BI Mini Master Class 1: Using a REST API as a data source
    • Power BI Master Class 1: COVID Tracker
    • Introduction to Power BI – FREE Online course
    • M Language + Power Query Course Bundle
    • Power Query Online Training [updated 2022]
    • M Language Online Course: The unofficial and Practical Reference Guide [updated 2025]
    • My Courses
  • Shop
    • Courses
    • Master Classes
    • Template Apps
    • JSON Themes
  • Cart
  • Register/ Log In
    • Become a Member
    • Log In
    • My account
    • My Courses
  • Search
  • Contact
You are here: Home / CM Tooltip Glossary Pro+ / SUMMARIZE

SUMMARIZE

posted on August 17, 2017

« Back to Glossary Index

Syntax

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

Tutorial with example

Learn how to use the function SUMMARIZE in DAX/ Powerpivot.

The function SUMMARIZE can return a summary of sales grouped around the calendar year and the product category name, this result table allows you to do analysis over the re-seller sales by year and product category.

Northwind data source: https://www.youtube.com/watch?v=k3NMI…
Icons: https://www.iconfinder.com/

DAX Fridays! #14: SUMMARIZE

Download example file:

To get the files:
1. Go to Curbal Download Center > Dax Fridays
2. Get File #14

Remarks

  1. Each column for which you define a name must have a corresponding expression; otherwise, an error is returned. The first argument, name, defines the name of the column in the results. The second argument, expression, defines the calculation performed to obtain the value for each row in that column.
  2. groupBy_columnName must be either in table or in a related table to table.
  3. Each name must be enclosed in double quotation marks.
  4. The function groups a selected set of rows into a set of summary rows by the values of one or more groupBy_columnName columns. One row is returned for each group.

Exercise 2: Create virtual tables

In this video I will show you how you create virtual tables in DAX to do calculations on them.

DAX Fridays #201: How to create virtual tables using DAX

Exercise 3: More virtual tables exercise

In today’s video I will show you how to create virtual tables to make more advanced calculations using ADDCOLUMNS and SUMMARIZE.

DAX Fridays! #143: ADDCOLUMNS and SUMMARIZE | Create virtual tables

Download example files:

To get the files:
1. Go to Curbal Download Center > Dax Fridays
2. Get File #143

Was this helpful?
Related Articles:
  • DAX Fridays! by Curbal
See Also:
  • ADDCOLUMNS
  • CURRENTGROUP
  • GROUPBY
  • ISSUBTOTAL
  • ROLLUP
« Back to Index

Reader Interactions

Comments

  1. Christopher Hastings

    August 23, 2018 at 9:08 pm

    Thank you so much for your great videos!

    Reply
    • Ruth Pozuelo Martinez

      August 28, 2018 at 12:01 pm

      My pleasure! 🙂
      /Ruth

      Reply

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Footer CTA

Join our community of +50,000 professionals

Become a Member

Subscribe to YouTube

About me:

Curbal AB
Badhusgatan 7B
722 15 – Västerås
Sweden

OrgNo: 5569680852 | VAT: SE556968085201

 

Location:

© Copyright 2014-2025 · Curbal AB · All Rights Reserved · Privacy Policy · Terms of Service · Refund Policy · Log In