Essential Sales DAX Measures 
1. Revenue
Total Revenue = SUM(Sales[Revenue])
Revenue MTD =
CALCULATE([Total Revenue], DATESMTD(DateTable[Date]))
Revenue YTD =
TOTALYTD([Total Revenue], DateTable[Date])
Revenue LY =
CALCULATE([Total Revenue], SAMEPERIODLASTYEAR(DateTable[Date]))
Revenue Growth % =
DIVIDE([Revenue YTD] - [Revenue LY], [Revenue LY], 0)
Tracks sales revenue month-to-date, year-to-date, and compares with last year.
2. Sales Quota Attainment
Quota Attainment % =
DIVIDE([Total Revenue], SUM(Sales[Quota]), 0)
Quota Attainment YTD =
TOTALYTD([Quota Attainment %], DateTable[Date])
Measures how much of the sales target has been achieved.
3. Pipeline & Opportunities
Total Opportunities = COUNTROWS(OpportunityTable)
Opportunities Won =
CALCULATE(COUNTROWS(OpportunityTable), OpportunityTable[Status] = "Won")
Win Rate % =
DIVIDE([Opportunities Won], [Total Opportunities], 0)
Win Rate YTD =
TOTALYTD([Win Rate %], DateTable[Date])
Tracks pipeline health and conversion efficiency.
4. Average Deal Size
Average Deal Size =
DIVIDE([Total Revenue], [Opportunities Won], 0)
Average Deal Size YTD =
TOTALYTD([Average Deal Size], DateTable[Date])
Shows the average value of closed deals.
5. Sales Cycle Length
Average Sales Cycle =
AVERAGEX(OpportunityTable, DATEDIFF(OpportunityTable[CreatedDate], OpportunityTable[CloseDate], DAY))
Sales Cycle YTD =
TOTALYTD([Average Sales Cycle], DateTable[Date])
Measures efficiency from lead creation to deal closure.
6. Customer Segmentation
Revenue by Segment =
CALCULATE([Total Revenue], Customer[Segment] = "Enterprise")
Revenue by Segment YTD =
TOTALYTD([Revenue by Segment], DateTable[Date])
Breaks down revenue by customer type (Enterprise, SMB, etc.).
7. Salesperson Performance
Revenue per Salesperson =
SUMX(VALUES(Sales[Salesperson]), [Total Revenue])
Revenue per Salesperson YTD =
TOTALYTD([Revenue per Salesperson], DateTable[Date])
Compares individual contributions to team performance.
Takeaway
These measures give Sales teams time-based insights into revenue, pipeline, deal size, win rates, and quota attainment. By layering date intelligence functions (DATESMTD, TOTALYTD, SAMEPERIODLASTYEAR), you can present monthly, yearly, and historical comparisons that drive better forecasting and coaching.
Comments
Post a Comment