Applicants per Hire
Requisition · Funnel
DIVIDE([Total Applicants], [Filled])Direct dependencies: Total Applicants, Filled
people analytics dashboard
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.
Selected page
Exact source expressions and direct measure dependencies for the selected page.
Requisition · Funnel
DIVIDE([Total Applicants], [Filled])Direct dependencies: Total Applicants, Filled
Requisition · Pipeline
CALCULATE(COUNTROWS(Requisition), KEEPFILTERS(Requisition[status] = "Filled"))Direct dependencies: None
Requisition · Funnel
DIVIDE([Total Interviewed], [Total Screened])Direct dependencies: Total Interviewed, Total Screened
Requisition · Funnel
DIVIDE([Offers Accepted], [Offers Extended])Direct dependencies: Offers Accepted, Offers Extended
Requisition · Funnel
SUM(Requisition[offersAccepted])Direct dependencies: None
Requisition · Funnel
SUM(Requisition[offersExtended])Direct dependencies: None
Requisition · Funnel
DIVIDE([Total Screened], [Total Applicants])Direct dependencies: Total Screened, Total Applicants
Requisition · Funnel
SUM(Requisition[applicants])Direct dependencies: None
Requisition · Funnel
SUM(Requisition[interviewed])Direct dependencies: None
Requisition · Funnel
SUM(Requisition[screened])Direct dependencies: None