set_summarize_by
Set a column's default aggregation for Power BI visuals. Choose from sum, min, max, count, average, distinct count, or none to avoid silently summing ID columns.
Instructions
Set a column's default summarization (the implicit aggregation used when the column is dropped on a visual). summarizeBy = Default | None | Sum | Min | Max | Count | Average | DistinctCount. Set None on key/ID columns so they are not silently summed.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| table | Yes | ||
| column | Yes | ||
| sessionId | Yes | ||
| summarizeBy | Yes | Default | None | Sum | Min | Max | Count | Average | DistinctCount |