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 — 1 TA summary

Selected page

1 TA summary

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

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

Open

Requisition · Pipeline

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

Direct dependencies: None

Open Over SLA

Requisition · Time

CALCULATE(COUNTROWS(Requisition), KEEPFILTERS(Requisition[status] = "Open"), FILTER(Requisition, Requisition[daysOpen] > LOOKUPVALUE(Parameters[value], Parameters[name], "OpenSlaDays")))

Direct dependencies: None

Requisitions

Requisition · Pipeline

COUNTROWS(Requisition)

Direct dependencies: None

TA Status Text

Requisition · Report Views

IF([Requisitions] = 0 || ISBLANK([Filled]), BLANK(), FORMAT([Filled], "#,0") & " of " & FORMAT([Requisitions], "#,0") & " requisitions filled, " & FORMAT([Open] + 0, "#,0") & " open (" & FORMAT([Open Over SLA] + 0, "#,0") & " over the service level). Average time to fill " & FORMAT([Average Time to Fill (Days)], "0.0") & " days; offer acceptance " & FORMAT([Offer Acceptance Rate], "0.0%") & "; cost per hire " & FORMAT([Cost per Hire], "$#,0") & ".")

Direct dependencies: Requisitions, Filled, Open, Open Over SLA, Average Time to Fill (Days), Offer Acceptance Rate, Cost per Hire

Total Recruiting Cost

Requisition · Cost

SUM(Requisition[costPerHireUsd])

Direct dependencies: None