About Subtotal Calculation in Calculated Measures

Find examples of using the Subtotal Calculation option when creating a calculated measure.

When the Subtotal Calculation checkbox is selected, subtotals are computed by computing the result of the formula with the base number's subtotals. When this option is clear, the subtotals are computed as a summary of the calculated number's different values.

The two subtotal approaches are shown in the following tables.

Table 1. Regular Subtotals
Column XColumn YCalculated Column X/Y
X1Y1X1/Y1
X2Y2X2/Y2
Subtotal (X1,X2)Subtotal (Y1,Y2)Subtotal (X1/Y1, X2,Y2)
Table 2. Subtotals Using Formula
Column XColumn YCalculated Column X/Y
X1Y1X1/Y1
X2Y2X2/Y2
Subtotal (X1,X2)Subtotal (Y1,Y2)Subtotal (X1,X2)/Subtotal (Y1,Y2)