Engagement and Exit

Survey, participation, segment, climate, driver, and exit-survey measures.

9 pages · Power BI

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

Choose page — 2 Factors and items

Selected page

2 Factors and items

DAX definitions

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

Average Score

SurveyResponse · Scores

IF([Respondents] >= 10, CALCULATE(AVERAGE(SurveyResponse[score]), KEEPFILTERS(SurveyResponse[wave] = 2023)), BLANK())

Direct dependencies: Respondents

Change in Favorable % (points)

SurveyResponse · Year over Year

IF(ISBLANK([Favorable %]) || ISBLANK([Favorable % (Prior Wave)]), BLANK(), [Favorable %] - [Favorable % (Prior Wave)])

Direct dependencies: Favorable %, Favorable % (Prior Wave)

Favorable %

SurveyResponse · Scores

IF([Respondents] >= 10, DIVIDE(CALCULATE(SUM(SurveyResponse[favorable]), KEEPFILTERS(SurveyResponse[wave] = 2023)), [Responses]), BLANK())

Direct dependencies: Respondents, Responses

Favorable % (Prior Wave)

SurveyResponse · Year over Year

IF([Respondents (Prior Wave)] >= 10, DIVIDE(CALCULATE(SUM(SurveyResponse[favorable]), KEEPFILTERS(SurveyResponse[wave] = 2022)), CALCULATE(COUNTROWS(SurveyResponse), KEEPFILTERS(SurveyResponse[wave] = 2022))), BLANK())

Direct dependencies: Respondents (Prior Wave)

Gap to Illustrative Industry Median (points)

SurveyResponse · Benchmarks

IF(ISBLANK([Favorable %]) || ISBLANK([Illustrative Benchmark % (Industry median)]), BLANK(), [Favorable %] - [Illustrative Benchmark % (Industry median)])

Direct dependencies: Favorable %, Illustrative Benchmark % (Industry median)

Illustrative Benchmark % (Industry median)

SurveyResponse · Benchmarks

IF(HASONEVALUE(SurveyResponse[factor]), LOOKUPVALUE(Benchmarks[favorablePct], Benchmarks[cohort], "Industry median", Benchmarks[factor], SELECTEDVALUE(SurveyResponse[factor])), BLANK())

Direct dependencies: None

Neutral %

SurveyResponse · Scores

IF([Respondents] >= 10, DIVIDE(CALCULATE(SUM(SurveyResponse[neutral]), KEEPFILTERS(SurveyResponse[wave] = 2023)), [Responses]), BLANK())

Direct dependencies: Respondents, Responses

Respondents

SurveyResponse · Participation & Volume

VAR __n = CALCULATE(DISTINCTCOUNT(SurveyResponse[respondentId]), KEEPFILTERS(SurveyResponse[wave] = 2023)) RETURN IF(__n >= 10, __n, BLANK())

Direct dependencies: None

Respondents (Prior Wave)

SurveyResponse · Participation & Volume

CALCULATE(DISTINCTCOUNT(SurveyResponse[respondentId]), KEEPFILTERS(SurveyResponse[wave] = 2022))

Direct dependencies: None

Responses

SurveyResponse · Participation & Volume

CALCULATE(COUNTROWS(SurveyResponse), KEEPFILTERS(SurveyResponse[wave] = 2023))

Direct dependencies: None

Unfavorable %

SurveyResponse · Scores

IF([Respondents] >= 10, DIVIDE(CALCULATE(SUM(SurveyResponse[unfavorable]), KEEPFILTERS(SurveyResponse[wave] = 2023)), [Responses]), BLANK())

Direct dependencies: Respondents, Responses