Talent Acquisition Funnel

Recruiting funnel, time-to-fill, source, quality, cost, and requisition views.

7 pages · Power BI

These dashboards use synthetic workforce data. Values illustrate the report design.

Choose page — 5 Source and quality

Selected page

5 Source and quality

DAX definitions

Exact source expressions and direct measure dependencies for the selected page.

Average Time to Fill (Days)

Requisition · Time

AVERAGE(Requisition[daysToFill])

Direct dependencies: None

Cost per Hire

Requisition · Cost

DIVIDE([Total Recruiting Cost], [Filled])

Direct dependencies: Total Recruiting Cost, Filled

Filled

Requisition · Pipeline

CALCULATE(COUNTROWS(Requisition), KEEPFILTERS(Requisition[status] = "Filled"))

Direct dependencies: None

First-Year Retention

Requisition · Quality

VAR __n = CALCULATE(COUNTROWS(Requisition), KEEPFILTERS(Requisition[observed12m] = "Yes")) RETURN IF(__n >= 10, DIVIDE(CALCULATE(COUNTROWS(Requisition), KEEPFILTERS(Requisition[retained12m] = "Yes")), __n), BLANK())

Direct dependencies: None

Offer Acceptance Rate

Requisition · Funnel

DIVIDE([Offers Accepted], [Offers Extended])

Direct dependencies: Offers Accepted, Offers Extended

Offers Accepted

Requisition · Funnel

SUM(Requisition[offersAccepted])

Direct dependencies: None

Offers Extended

Requisition · Funnel

SUM(Requisition[offersExtended])

Direct dependencies: None

Quality of Hire (Avg First-Year Rating)

Requisition · Quality

VAR __n = COUNTROWS(FILTER(Requisition, NOT ISBLANK(Requisition[hireQualityScore]))) RETURN IF(__n >= 10, AVERAGE(Requisition[hireQualityScore]), BLANK())

Direct dependencies: None

Source Share of Hires

Requisition · Source

DIVIDE([Filled], CALCULATE([Filled], REMOVEFILTERS(Requisition[source])))

Direct dependencies: Filled

Total Recruiting Cost

Requisition · Cost

SUM(Requisition[costPerHireUsd])

Direct dependencies: None