DAX Function

SUMMARIZE Power BI DAX exercises.

These concepts all use SUMMARIZE. Work through related PBIX exercises, compare the patterns, and submit numeric answers to save your progress.

View all DAX functions

3Related concepts

Concepts Using SUMMARIZE

IntermediateSUMMARIZE

Calculating Aggregate Film Statistics by Genre Using SUMMARIZE

Learn how to use the SUMMARIZE function to group data and calculate aggregate measures such as average film length and total Oscars won per genre.

Open

IntermediateVALUES CONCATENATEX SELECTEDVALUE RELATED SUMMARIZE

Creating Dynamic Labels and Tooltips with DAX Measures

Learn to create dynamic labels for card visuals and detailed tooltips for charts using various DAX functions to enhance report interactivity and user experience.

Open

AdvancedCALCULATE DATEADD DATESYTD SAMEPERIODLASTYEAR DATESINPERIOD DIVIDE SUM AVERAGEX SUMMARIZE ADDCOLUMNS

Mastering Advanced Time Intelligence Measures in DAX

Create three complex DAX time intelligence measures: a quarter-over-quarter percentage, a year-to-date percentage against the previous full year, and a three-month moving average of monthly totals.

Open