Default Summarization

  1. Set Dimensions to Don't summarize
    • By default, whole number, decimal number, and fixed decimal number are set to Sum
  2. Default Summarization Modeling Option
  3. Select each dimension table column and revise Default Summarization to Don't Summarize:
    • The Fields list applies a summation symbol and sums the column's values when selected for a report visual 
Default Summarization in Fields List
    • The same symbol is applied regardless of the Default Summarization configured (for example, Average and Count)
In this example, ...

Get Microsoft Power BI Cookbook now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.