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 — 2 My org vs company

Selected page

2 My org vs company

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

Benchmark Display

OrgScorecard · Display

IF(ISEMPTY(AsOf), BLANK(), IF(ISBLANK([Company Value]), BLANK(), FORMAT([Company Value], SELECTEDVALUE(OrgScorecard[format]), "en-US")))

Direct dependencies: Company Value

Company Value

OrgScorecard · Comparison

IF(ISEMPTY(AsOf), BLANK(), IF(COUNTROWS(OrgScorecard) = 1, SELECTEDVALUE(OrgScorecard[companyValue]), 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

Comparison Status

OrgScorecard · Comparison

IF(ISEMPTY(AsOf), BLANK(), IF(COUNTROWS(OrgScorecard) = 1 && SELECTEDVALUE(OrgScorecard[n]) >= 10 && SELECTEDVALUE(OrgScorecard[suppressed]) = 0, SELECTEDVALUE(OrgScorecard[status]), BLANK()))

Direct dependencies: None

Gap to Company

OrgScorecard · Comparison

IF(ISEMPTY(AsOf), BLANK(), IF(ISBLANK([Org Value]) || ISBLANK([Company Value]), BLANK(), [Org Value] - [Company Value]))

Direct dependencies: Org Value, Company Value

Org Display

OrgScorecard · Display

IF(ISEMPTY(AsOf), BLANK(), IF(ISBLANK([Org Value]), BLANK(), FORMAT([Org Value], SELECTEDVALUE(OrgScorecard[format]), "en-US")))

Direct dependencies: Org Value

Org Value

OrgScorecard · Comparison

IF(ISEMPTY(AsOf), BLANK(), IF(COUNTROWS(OrgScorecard) = 1 && SELECTEDVALUE(OrgScorecard[n]) >= 10 && SELECTEDVALUE(OrgScorecard[suppressed]) = 0, SELECTEDVALUE(OrgScorecard[orgValue]), BLANK()))

Direct dependencies: None

Relative Gap to Company

OrgScorecard · Comparison

IF(ISEMPTY(AsOf), BLANK(), IF(ISBLANK([Gap to Company]), BLANK(), DIVIDE([Gap to Company], ABS([Company Value]))))

Direct dependencies: Gap to Company, Company Value

Your Org vs Company

OrgScorecard · Narrative

IF(ISEMPTY(AsOf), BLANK(), IF(NOT (HASONEVALUE(OrgScorecard[department]) && COUNTROWS(OrgScorecard) > 0), "Choose one department for Your org vs company; tables can show all orgs.", IF([Comparable Metrics] = 0, "ILLUSTRATIVE: no comparable metrics available. Neutral, missing and suppressed metrics are excluded. Screening, not a verdict.", "ILLUSTRATIVE: " & SELECTEDVALUE(OrgScorecard[department]) & " vs company: " & FORMAT([# Metrics Better than Company], "0", "en-US") & " better, " & FORMAT([# Metrics Similar than Company], "0", "en-US") & " similar, " & FORMAT([# Metrics Worse than Company], "0", "en-US") & " worse of " & FORMAT([Comparable Metrics], "0", "en-US") & " comparable metrics. Screening, not a verdict.")))

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