上QQ阅读APP看书，第一时间看更新
Default Summarization
- Set Dimensions to Don't summarize.
- By default, whole number, decimal number, and fixed decimal number are set to Sum
-
Default Summarization Modeling Option
- 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, Days to Manufacture and Dealer Price would be summed as though they're measures. In most scenarios, the user intent is to group the data by these columns rather than sum.
- Default Summarization can be accessed from either the Data View or the Report View
Default Summarization
Simple DAX measures can deliver all Default Summarization options ( Sum, Min, Max, Average, Count, and Count Distinct). Additionally, measure names such as Count of Products eliminate confusion of the Default Summarization icon.
- Replace fact columns with measures:
- Develop DAX measures with aggregation functions and formatting such that fact columns can be hidden
- When all fact columns are hidden, associated measures will display at the top of the Field list
- Measures with names such as Count of Products avoid the confusion of which summarization is applied
- Additionally, measures allow for business logic to be applied, such as including or excluding certain values
The quick measures feature can be used as an alternative to Default Summarization as well.
-
- The end result should be the elimination of Default Summarization settings from all columns exposed in the Field List