Executive

A five-page executive report spanning the overview, KPI summary, organizational comparison, scorecard, and definitions.

5 pages · Power BI

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

Choose page — 3 Scorecard by area

Selected page

3 Scorecard by area

DAX definitions

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

# Metrics Better than Company

OrgScorecard · Screening

IF(ISEMPTY(AsOf), BLANK(), IF(HASONEVALUE(OrgScorecard[department]) && COUNTROWS(OrgScorecard) > 0, COUNTROWS(FILTER(OrgScorecard, OrgScorecard[n] >= 10 && OrgScorecard[suppressed] = 0 && NOT ISBLANK(OrgScorecard[orgValue]) && NOT ISBLANK(OrgScorecard[companyValue]) && OrgScorecard[status] = "Better")) + 0, BLANK()))

Direct dependencies: None

# Metrics Similar than Company

OrgScorecard · Screening

IF(ISEMPTY(AsOf), BLANK(), IF(HASONEVALUE(OrgScorecard[department]) && COUNTROWS(OrgScorecard) > 0, COUNTROWS(FILTER(OrgScorecard, OrgScorecard[n] >= 10 && OrgScorecard[suppressed] = 0 && NOT ISBLANK(OrgScorecard[orgValue]) && NOT ISBLANK(OrgScorecard[companyValue]) && OrgScorecard[status] = "Similar")) + 0, BLANK()))

Direct dependencies: None

# Metrics Worse than Company

OrgScorecard · Screening

IF(ISEMPTY(AsOf), BLANK(), IF(HASONEVALUE(OrgScorecard[department]) && COUNTROWS(OrgScorecard) > 0, COUNTROWS(FILTER(OrgScorecard, OrgScorecard[n] >= 10 && OrgScorecard[suppressed] = 0 && NOT ISBLANK(OrgScorecard[orgValue]) && NOT ISBLANK(OrgScorecard[companyValue]) && OrgScorecard[status] = "Worse")) + 0, BLANK()))

Direct dependencies: None

Comparable Metrics

OrgScorecard · Screening

IF(ISEMPTY(AsOf), BLANK(), IF(HASONEVALUE(OrgScorecard[department]) && COUNTROWS(OrgScorecard) > 0, [# Metrics Better than Company] + [# Metrics Similar than Company] + [# Metrics Worse than Company], BLANK()))

Direct dependencies: # Metrics Better than Company, # Metrics Similar than Company, # Metrics Worse than Company

Share Worse

OrgScorecard · Screening

IF(ISEMPTY(AsOf), BLANK(), DIVIDE([# Metrics Worse than Company], [Comparable Metrics]))

Direct dependencies: # Metrics Worse than Company, Comparable Metrics

Suppressed Metric Count

OrgScorecard · Screening

IF(ISEMPTY(AsOf), BLANK(), IF(HASONEVALUE(OrgScorecard[department]) && COUNTROWS(OrgScorecard) > 0, COUNTROWS(FILTER(OrgScorecard, OrgScorecard[suppressed] = 1)) + 0, BLANK()))

Direct dependencies: None