Power BI
Power BI KPI DAX Measures
Copy ready-to-adapt DAX measure patterns for business KPIs used in Power BI dashboards and reports.
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.
Power BI KPI DAX measures books
Books that help you understand Power BI KPI DAX measures and related business metrics more deeply.
Explore resources →
Power BI KPI DAX measures audiobooks
Audiobook searches for learning Power BI KPI DAX measures while commuting, walking, or working.
Explore resources →
Power BI KPI DAX measures Excel resources
Excel-focused resources for building KPI trackers and dashboard workflows.
Explore resources →
Power BI KPI DAX measures dashboard tools
Practical resources for turning Power BI KPI DAX measures into reports, dashboards, and business decisions.
Explore resources →
DAX KPI measure examples
Rename tables, columns, and base measures to match your Power BI model.
Gross Margin
Gross Margin =
DIVIDE(
[Revenue] - [Cost of Goods Sold],
[Revenue]
)EBITDA
EBITDA =
[Net Income] + [Interest] + [Taxes] + [Depreciation] + [Amortization]Revenue Growth Rate
Revenue Growth Rate =
DIVIDE(
[Current Revenue] - [Previous Revenue],
[Previous Revenue]
)Free Cash Flow
Free Cash Flow =
[Operating Cash Flow] - [Capital Expenditures]Return on Equity
Return on Equity =
DIVIDE(
[Net Income],
[Shareholders Equity]
)Return on Invested Capital
Return on Invested Capital =
DIVIDE(
[NOPAT],
[Invested Capital]
)WACC
WACC =
VAR EquityValue = [Equity Value]
VAR DebtValue = [Debt Value]
VAR TotalCapital = EquityValue + DebtValue
RETURN
DIVIDE(EquityValue, TotalCapital) * [Cost of Equity]
+ DIVIDE(DebtValue, TotalCapital) * [Cost of Debt] * (1 - [Tax Rate])Debt-to-Equity Ratio
Debt-to-Equity Ratio =
DIVIDE(
[Total Debt],
[Total Equity]
)Current Ratio
Current Ratio =
DIVIDE(
[Current Assets],
[Current Liabilities]
)Quick Ratio
Quick Ratio =
DIVIDE(
[Cash] + [Marketable Securities] + [Accounts Receivable],
[Current Liabilities]
)Interest Coverage Ratio
Interest Coverage Ratio =
DIVIDE(
[EBIT],
[Interest Expense]
)Accounts Receivable Turnover
Accounts Receivable Turnover =
DIVIDE(
[Net Credit Sales],
[Average Accounts Receivable]
)Accounts Payable Turnover
Accounts Payable Turnover =
DIVIDE(
[Net Credit Purchases],
[Average Accounts Payable]
)Days Sales Outstanding
Days Sales Outstanding =
DIVIDE([Accounts Receivable], [Credit Sales]) * [Days]Days Payable Outstanding
Days Payable Outstanding =
DIVIDE([Accounts Payable], [Cost of Goods Sold]) * [Days]Inventory Turnover
Inventory Turnover =
DIVIDE(
[Cost of Goods Sold],
[Average Inventory]
)Working Capital Ratio
Working Capital Ratio =
DIVIDE(
[Current Assets],
[Current Liabilities]
)Operating Cash Flow Ratio
Operating Cash Flow Ratio =
DIVIDE(
[Operating Cash Flow],
[Current Liabilities]
)Customer Acquisition Cost
CAC =
DIVIDE(
[Sales and Marketing Cost],
[New Customers]
)Marketing ROI
Marketing ROI =
DIVIDE(
[Revenue from Marketing] - [Marketing Cost],
[Marketing Cost]
)Lead Conversion Rate
Lead Conversion Rate =
DIVIDE(
[Converted Leads],
[Total Leads]
)Website Conversion Rate
Website Conversion Rate =
DIVIDE(
[Website Conversions],
[Website Visitors]
)Email Open Rate
Email Open Rate =
DIVIDE(
[Emails Opened],
[Emails Delivered]
)Email Click Rate
Email Click Rate =
DIVIDE(
[Email Clicks],
[Emails Delivered]
)Bounce Rate
Bounce Rate =
DIVIDE(
[Single-Page Sessions],
[Total Sessions]
)Impression Share
Impression Share =
DIVIDE(
[Impressions Received],
[Eligible Impressions]
)Sales Velocity
Sales Velocity =
DIVIDE(
[Opportunities] * [Average Deal Size] * [Win Rate],
[Sales Cycle Length]
)Average Deal Size
Average Deal Size =
DIVIDE(
[Total Revenue],
[Number of Deals]
)Sales Cycle Length
Sales Cycle Length =
DIVIDE(
[Total Days to Close Deals],
[Closed Deals]
)Pipeline Coverage
Pipeline Coverage =
DIVIDE(
[Pipeline Value],
[Sales Target]
)Revenue per Sales Rep
Revenue per Sales Rep =
DIVIDE(
[Total Revenue],
[Sales Reps]
)Lead-to-Customer Rate
Lead-to-Customer Rate =
DIVIDE(
[New Customers],
[Leads]
)Opportunity Conversion Rate
Opportunity Conversion Rate =
DIVIDE(
[Converted Opportunities],
[Total Opportunities]
)Forecast Accuracy
Forecast Accuracy =
1 - DIVIDE(ABS([Forecast] - [Actual]), [Actual])Average Revenue per Account
Average Revenue per Account =
DIVIDE(
[Revenue],
[Accounts]
)Sales Growth Rate
Sales Growth Rate =
DIVIDE([Current Sales] - [Previous Sales], [Previous Sales])Customer Churn
Customer Churn =
DIVIDE(
[Customers Lost],
[Customers at Start]
)Net Revenue Retention
NRR =
DIVIDE(
[Starting MRR] + [Expansion MRR] - [Contraction MRR] - [Churned MRR],
[Starting MRR]
)Gross Revenue Retention
GRR =
DIVIDE(
[Starting MRR] - [Contraction MRR] - [Churned MRR],
[Starting MRR]
)CAC Payback Period
CAC Payback Period =
DIVIDE(
[CAC],
[Monthly Gross Profit per Customer]
)Logo Retention
Logo Retention =
DIVIDE(
[Retained Customers],
[Starting Customers]
)SaaS Quick Ratio
SaaS Quick Ratio =
DIVIDE(
[New MRR] + [Expansion MRR],
[Churned MRR] + [Contraction MRR]
)Magic Number
Magic Number =
DIVIDE(
([Current Quarter ARR] - [Previous Quarter ARR]) * 4,
[Previous Quarter Sales and Marketing Spend]
)Capacity Utilization
Capacity Utilization =
DIVIDE(
[Actual Output],
[Maximum Possible Output]
)