Column and measure metadata
Dataset designers should review the columns and measures of each table exposed to the Report view and ensure that appropriate metadata properties have been configured. These settings, including any custom sorting described earlier in the Custom sort section of this chapter, only need to be applied once and can significantly improve the usability of the dataset.
In the following sections, we explore some of the more important metadata settings for columns and measures. Some of these apply only to columns, such as the Default summarization setting explained in the next section.
Default summarization
As mentioned, the Default summarization property only applies to columns and controls the default aggregation applied to a column such as sum, average, first, last, and so on.
The Default summarization property should be revised from Power BI’s default setting to the Do not summarize value for all columns. Power BI applies a Default summarization...
