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 — 4 Segments and gaps

Selected page

4 Segments and gaps

DAX definitions

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

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)

Engagement Favorable %

SurveyResponse · Scores

CALCULATE([Favorable %], KEEPFILTERS(SurveyResponse[factor] = "Engagement"))

Direct dependencies: Favorable %

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)

Manager Favorable %

SurveyResponse · Scores

CALCULATE([Favorable %], KEEPFILTERS(SurveyResponse[isManagerItem] = "Yes"))

Direct dependencies: Favorable %

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