The Summarize function creates a table.
You cannot use it by itself in a measure.
Use New Table to create a table using the summarize function:
If you want to use it in a measure, you need to do something with the table.
AggregateX functions like MaxX, AverageX and SumX let you aggregate the rows of data.
Here for example I am using Summarize to calculate for each Quantity what the Sum of Price is.
Then using AggergateX to return the overall average.
The Summarize function creates a table.
You cannot use it by itself in a measure.
Use New Table to create a table using the summarize function:
If you want to use it in a measure, you need to do something with the table.
AggregateX functions like MaxX, AverageX and SumX let you aggregate the rows of data.
Here for example I am using Summarize to calculate for each Quantity what the Sum of Price is.
Then using AggergateX to return the overall average.
Helpful resources
Join us at the Microsoft Fabric Community Conference
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Power BI Monthly Update - January 2025
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
A Year in Review - December 2024
Find out what content was popular in the Fabric community during 2024.
