KKPI Formulas
Power BI DAX

SaaS DAX Measures

Copy DAX measure examples for common saas KPIs used in Power BI dashboards.

Affiliate resources

Ideas for You

Useful learning resources related to this page. As an Amazon Associate, this site may earn from qualifying purchases at no extra cost to you.

SaaS Power BI dashboard books Books that help you understand SaaS Power BI dashboard and related business metrics more deeply. Explore resources → SaaS Power BI dashboard audiobooks Audiobook searches for learning SaaS Power BI dashboard while commuting, walking, or working. Explore resources → Startup metrics resources Excel-focused resources for building KPI trackers and dashboard workflows. Explore resources → Subscription business resources Practical resources for turning SaaS Power BI dashboard into reports, dashboards, and business decisions. Explore resources →

SaaS KPI DAX examples

MRR
MRR =
SUM(Subscriptions[MonthlyRecurringRevenue])

Full MRR guide →

ARR
ARR =
[MRR] * 12

Full ARR guide →

Churn Rate
Churn Rate =
DIVIDE(
    [Lost Customers],
    [Customers at Start]
)

Full Churn Rate guide →

Revenue Churn
Revenue Churn =
DIVIDE(
    [Lost MRR],
    [Starting MRR]
)

Full Revenue Churn guide →

Customer Churn
Customer Churn =
DIVIDE(
    [Customers Lost],
    [Customers at Start]
)

Full Customer Churn guide →

Net Revenue Retention
NRR =
DIVIDE(
    [Starting MRR] + [Expansion MRR] - [Contraction MRR] - [Churned MRR],
    [Starting MRR]
)

Full Net Revenue Retention guide →

Gross Revenue Retention
GRR =
DIVIDE(
    [Starting MRR] - [Contraction MRR] - [Churned MRR],
    [Starting MRR]
)

Full Gross Revenue Retention guide →

LTV
LTV =
DIVIDE([ARPU] * [Gross Margin], [Churn Rate])

Full LTV guide →

LTV:CAC Ratio
LTV CAC Ratio =
DIVIDE(
    [LTV],
    [CAC]
)

Full LTV:CAC Ratio guide →

CAC Payback Period
CAC Payback Period =
DIVIDE(
    [CAC],
    [Monthly Gross Profit per Customer]
)

Full CAC Payback Period guide →

ARPU
ARPU =
DIVIDE(
    [Revenue],
    [Users]
)

Full ARPU guide →

ARPA
ARPA =
DIVIDE(
    [Revenue],
    [Accounts]
)

Full ARPA guide →

Expansion MRR
Expansion MRR =
SUM(Subscriptions[ExpansionMRR])

Full Expansion MRR guide →

Contraction MRR
Contraction MRR =
SUM(Subscriptions[ContractionMRR])

Full Contraction MRR guide →

Logo Retention
Logo Retention =
DIVIDE(
    [Retained Customers],
    [Starting Customers]
)

Full Logo Retention guide →

SaaS Quick Ratio
SaaS Quick Ratio =
DIVIDE(
    [New MRR] + [Expansion MRR],
    [Churned MRR] + [Contraction MRR]
)

Full SaaS Quick Ratio guide →

Magic Number
Magic Number =
DIVIDE(
    ([Current Quarter ARR] - [Previous Quarter ARR]) * 4,
    [Previous Quarter Sales and Marketing Spend]
)

Full Magic Number guide →

Rule of 40
Rule of 40 =
[Revenue Growth Rate] + [Profit Margin]

Full Rule of 40 guide →