SUMMARIZE

In the Ultra Transcenders books

PL-300

Each book explains SUMMARIZE in context, with comparison tables and the common traps.

Terms in this definition

• Event

  Table in Log Analytics where entries from Windows event logs are kept.

• DAX

  Short for Data Analysis Expressions, the formula language you write measures, calculated columns and row-level security rules in, within tabular semantic models in Power BI, Excel Power Pivot or Analysis Services.

• GROUP BY

  Collapses rows sharing the same values of chosen expressions into one row per bucket, with aggregate functions evaluated for each bucket. Writing GROUP BY ALL picks every expression in the select list that isn't an aggregate.

• Architecture Definition Document

  A key deliverable bringing together the main architecture artifacts across the four domains for every relevant state: baseline, transition and target. It sets out, in qualitative terms, what the architect intends.

• Aggregations

  Summary queries over a large DirectQuery table can be answered from memory instead of the source thanks to this semantic model feature: it keeps a concealed summary table cached and sends qualifying queries there, while anything needing fine detail still goes back to the source.

Related terms

• bin()

  A KQL function that groups values by rounding numbers, timespans or datetimes down to the nearest multiple of a chosen size; paired with summarize, bin(Timestamp, 1h) gives hourly buckets. floor() behaves the same way, and bin_at() lets you pick where the buckets start.

• Default summarization

  A setting on a numeric column that decides which aggregation, such as Sum or Average, Power BI applies when the column is dropped into a visual. Identifier and year columns are best set to Don't summarize.