Power BI DAX
Sales DAX Measures
Copy DAX measure examples for common sales 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.
Sales Power BI dashboard books
Books that help you understand Sales Power BI dashboard and related business metrics more deeply.
Explore resources →
Sales Power BI dashboard audiobooks
Audiobook searches for learning Sales Power BI dashboard while commuting, walking, or working.
Explore resources →
Sales dashboard resources
Excel-focused resources for building KPI trackers and dashboard workflows.
Explore resources →
Sales management resources
Practical resources for turning Sales Power BI dashboard into reports, dashboards, and business decisions.
Explore resources →
Sales KPI DAX examples
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]
)Quota Attainment
Quota Attainment =
DIVIDE(
[Actual Sales],
[Sales Quota]
)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])