Schema Theory

Description

This KPI measures the average revenue generated per user over a specific period, commonly used in subscription-based businesses.

Visual Example

DAX Formula

ARPU = 
    DIVIDE(
        SUM(Sales[Revenue]),
        DISTINCTCOUNT(Sales[UserID])
    )          

SQL Statement

SELECT 
      SUM(Revenue) * 1.0 / COUNT(DISTINCT UserID) AS ARPU
    FROM 
      Sales
    WHERE 
      Revenue IS NOT NULL AND UserID IS NOT NULL;    

Usage Notes

• Ensure the Sales table includes a Revenue column and a UserID column.
• The formula calculates ARPU based on unique users who generated revenue during the period.
• Filter the data to include only transactions within the desired time period (e.g., monthly ARPU).

Downloads