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
FabCon & SQLCon – Barcelona 2026
Join us in Barcelona for FabCon and SQLCon, the Fabric, Power BI, SQL, and AI community event. Save €200 with code FABCMTY200.
Fabric Community Sticker Challenge - Barcelona 2026
If you love stickers, then you will definitely want to check out our community sticker challenge, Barcelona edition!
Power BI Monthly Update - July 2026
Check out the July 2026 Power BI update to learn about new features.
Power BI DataViz World Championships - June 2026
A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.
