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

Be the first to post a comment.