How do you distinguish additive, semi-additive, and non-additive measures in practice?

In practice, the distinction comes from how a measure behaves when you aggregate it across dimensions like time, product, or region.

Additive measures can be summed across all dimensions without losing meaning.
Example: sales revenue, units sold, transaction counts. Summing them across days, stores, or regions still produces a correct total.

Semi-additive measures can be aggregated across some dimensions but not across time.
Example: account balances, inventory levels, or headcount. You can sum them across departments or locations, but summing across days would double-count. Instead, you usually take last value, average, or snapshot.

Non-additive measures cannot be meaningfully summed across any dimension because they are ratios or derived metrics.
Example: conversion rate, profit margin, or averages. These must be recalculated from underlying data rather than aggregated directly.

A practical rule:

• If summing preserves meaning → Additive

• If summing works except across time → Semi-additive

• If summing breaks the metric → Non-additive

In practice, the distinction becomes clear when you test aggregation across dimensions, especially time.

Additive measures can be summed across all dimensions.
Example: revenue, sales quantity. Summing across products, regions, or months still makes sense.

Semi-additive measures can be summed across some dimensions, but not all, typically not across time.
Example: account balance or inventory levels. You can sum across branches, but summing month-end balances across time is misleading.

Non-additive measures cannot be meaningfully summed across dimensions.
Example: ratios, percentages, averages like profit margin or conversion rate. These require weighted calculations instead of simple sums.

A practical rule:
If summing changes the business meaning, it is not fully additive. Always validate aggregation logic against the real-world interpretation of the metric.