RE: 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

Be the first to post a comment.

Add a comment