Workforce Economics

Return-on-people, rewards, benefits, and HRIS vendor measures.

6 pages · Power BI

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

Choose page — 3 Total rewards

Selected page

3 Total rewards

DAX definitions

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

Annual Total Rewards per FTE

EconEmployee · Rewards


VAR __benefitIds = VALUES(BenefitsPlan[employeeId])
VAR __people = FILTER(EconEmployee, NOT ISFILTERED(BenefitsPlan) || EconEmployee[employeeId] IN __benefitIds)
VAR __ids = SELECTCOLUMNS(__people, "__id", EconEmployee[employeeId])
VAR __plans = FILTER(BenefitsPlan, BenefitsPlan[employeeId] IN __ids)
VAR __n = COUNTROWS(__people) + 0
VAR __all = ALL(EconEmployee)
VAR __allN = COUNTROWS(__all) + 0
VAR __a = SUMX(__people, EconEmployee[revenueAttributedFte]) + 0
VAR __allA = SUMX(__all, EconEmployee[revenueAttributedFte]) + 0
VAR __base = SUMX(__people, EconEmployee[basePay]) + 0
VAR __bonus = SUMX(__people, EconEmployee[bonus]) + 0
VAR __benefits = SUMX(__people, EconEmployee[benefitsCost]) + 0
VAR __annualPay = __base + __bonus
VAR __rewards = SUMX(__people, EconEmployee[totalRewards]) + 0
VAR __allPay = SUMX(__all, EconEmployee[basePay] + EconEmployee[bonus]) + 0
VAR __allBenefits = SUMX(__all, EconEmployee[benefitsCost]) + 0
VAR __months = COUNTROWS(FinancialPeriod) + 0
VAR __pay = (SUM(FinancialPeriod[payExpense]) + 0) * DIVIDE(__annualPay, __allPay)
VAR __ben = (SUM(FinancialPeriod[benefitsExpense]) + 0) * DIVIDE(__benefits, __allBenefits)
VAR __cost = __pay + __ben
VAR __nonpeople = (SUMX(FinancialPeriod, FinancialPeriod[operatingExpense] - FinancialPeriod[payExpense] - FinancialPeriod[benefitsExpense]) + 0) * DIVIDE(__n, __allN)
VAR __rev = (SUM(FinancialPeriod[revenue]) + 0) * DIVIDE(__a, __allA)
RETURN IF(__n < 10 || ISEMPTY(AsOf), BLANK(), DIVIDE(__rewards, __n))

Direct dependencies: None

Base Pay Mix Share

EconEmployee · Rewards


VAR __benefitIds = VALUES(BenefitsPlan[employeeId])
VAR __people = FILTER(EconEmployee, NOT ISFILTERED(BenefitsPlan) || EconEmployee[employeeId] IN __benefitIds)
VAR __ids = SELECTCOLUMNS(__people, "__id", EconEmployee[employeeId])
VAR __plans = FILTER(BenefitsPlan, BenefitsPlan[employeeId] IN __ids)
VAR __n = COUNTROWS(__people) + 0
VAR __all = ALL(EconEmployee)
VAR __allN = COUNTROWS(__all) + 0
VAR __a = SUMX(__people, EconEmployee[revenueAttributedFte]) + 0
VAR __allA = SUMX(__all, EconEmployee[revenueAttributedFte]) + 0
VAR __base = SUMX(__people, EconEmployee[basePay]) + 0
VAR __bonus = SUMX(__people, EconEmployee[bonus]) + 0
VAR __benefits = SUMX(__people, EconEmployee[benefitsCost]) + 0
VAR __annualPay = __base + __bonus
VAR __rewards = SUMX(__people, EconEmployee[totalRewards]) + 0
VAR __allPay = SUMX(__all, EconEmployee[basePay] + EconEmployee[bonus]) + 0
VAR __allBenefits = SUMX(__all, EconEmployee[benefitsCost]) + 0
VAR __months = COUNTROWS(FinancialPeriod) + 0
VAR __pay = (SUM(FinancialPeriod[payExpense]) + 0) * DIVIDE(__annualPay, __allPay)
VAR __ben = (SUM(FinancialPeriod[benefitsExpense]) + 0) * DIVIDE(__benefits, __allBenefits)
VAR __cost = __pay + __ben
VAR __nonpeople = (SUMX(FinancialPeriod, FinancialPeriod[operatingExpense] - FinancialPeriod[payExpense] - FinancialPeriod[benefitsExpense]) + 0) * DIVIDE(__n, __allN)
VAR __rev = (SUM(FinancialPeriod[revenue]) + 0) * DIVIDE(__a, __allA)
RETURN IF(__n < 10 || ISEMPTY(AsOf), BLANK(), DIVIDE(__base, __rewards))

Direct dependencies: None

Benefits Mix Share

EconEmployee · Rewards


VAR __benefitIds = VALUES(BenefitsPlan[employeeId])
VAR __people = FILTER(EconEmployee, NOT ISFILTERED(BenefitsPlan) || EconEmployee[employeeId] IN __benefitIds)
VAR __ids = SELECTCOLUMNS(__people, "__id", EconEmployee[employeeId])
VAR __plans = FILTER(BenefitsPlan, BenefitsPlan[employeeId] IN __ids)
VAR __n = COUNTROWS(__people) + 0
VAR __all = ALL(EconEmployee)
VAR __allN = COUNTROWS(__all) + 0
VAR __a = SUMX(__people, EconEmployee[revenueAttributedFte]) + 0
VAR __allA = SUMX(__all, EconEmployee[revenueAttributedFte]) + 0
VAR __base = SUMX(__people, EconEmployee[basePay]) + 0
VAR __bonus = SUMX(__people, EconEmployee[bonus]) + 0
VAR __benefits = SUMX(__people, EconEmployee[benefitsCost]) + 0
VAR __annualPay = __base + __bonus
VAR __rewards = SUMX(__people, EconEmployee[totalRewards]) + 0
VAR __allPay = SUMX(__all, EconEmployee[basePay] + EconEmployee[bonus]) + 0
VAR __allBenefits = SUMX(__all, EconEmployee[benefitsCost]) + 0
VAR __months = COUNTROWS(FinancialPeriod) + 0
VAR __pay = (SUM(FinancialPeriod[payExpense]) + 0) * DIVIDE(__annualPay, __allPay)
VAR __ben = (SUM(FinancialPeriod[benefitsExpense]) + 0) * DIVIDE(__benefits, __allBenefits)
VAR __cost = __pay + __ben
VAR __nonpeople = (SUMX(FinancialPeriod, FinancialPeriod[operatingExpense] - FinancialPeriod[payExpense] - FinancialPeriod[benefitsExpense]) + 0) * DIVIDE(__n, __allN)
VAR __rev = (SUM(FinancialPeriod[revenue]) + 0) * DIVIDE(__a, __allA)
RETURN IF(__n < 10 || ISEMPTY(AsOf), BLANK(), DIVIDE(__benefits, __rewards))

Direct dependencies: None

Bonus Mix Share

EconEmployee · Rewards


VAR __benefitIds = VALUES(BenefitsPlan[employeeId])
VAR __people = FILTER(EconEmployee, NOT ISFILTERED(BenefitsPlan) || EconEmployee[employeeId] IN __benefitIds)
VAR __ids = SELECTCOLUMNS(__people, "__id", EconEmployee[employeeId])
VAR __plans = FILTER(BenefitsPlan, BenefitsPlan[employeeId] IN __ids)
VAR __n = COUNTROWS(__people) + 0
VAR __all = ALL(EconEmployee)
VAR __allN = COUNTROWS(__all) + 0
VAR __a = SUMX(__people, EconEmployee[revenueAttributedFte]) + 0
VAR __allA = SUMX(__all, EconEmployee[revenueAttributedFte]) + 0
VAR __base = SUMX(__people, EconEmployee[basePay]) + 0
VAR __bonus = SUMX(__people, EconEmployee[bonus]) + 0
VAR __benefits = SUMX(__people, EconEmployee[benefitsCost]) + 0
VAR __annualPay = __base + __bonus
VAR __rewards = SUMX(__people, EconEmployee[totalRewards]) + 0
VAR __allPay = SUMX(__all, EconEmployee[basePay] + EconEmployee[bonus]) + 0
VAR __allBenefits = SUMX(__all, EconEmployee[benefitsCost]) + 0
VAR __months = COUNTROWS(FinancialPeriod) + 0
VAR __pay = (SUM(FinancialPeriod[payExpense]) + 0) * DIVIDE(__annualPay, __allPay)
VAR __ben = (SUM(FinancialPeriod[benefitsExpense]) + 0) * DIVIDE(__benefits, __allBenefits)
VAR __cost = __pay + __ben
VAR __nonpeople = (SUMX(FinancialPeriod, FinancialPeriod[operatingExpense] - FinancialPeriod[payExpense] - FinancialPeriod[benefitsExpense]) + 0) * DIVIDE(__n, __allN)
VAR __rev = (SUM(FinancialPeriod[revenue]) + 0) * DIVIDE(__a, __allA)
RETURN IF(__n < 10 || ISEMPTY(AsOf), BLANK(), DIVIDE(__bonus, __rewards))

Direct dependencies: None

Economics Population

EconEmployee · Population


VAR __benefitIds = VALUES(BenefitsPlan[employeeId])
VAR __people = FILTER(EconEmployee, NOT ISFILTERED(BenefitsPlan) || EconEmployee[employeeId] IN __benefitIds)
VAR __ids = SELECTCOLUMNS(__people, "__id", EconEmployee[employeeId])
VAR __plans = FILTER(BenefitsPlan, BenefitsPlan[employeeId] IN __ids)
VAR __n = COUNTROWS(__people) + 0
VAR __all = ALL(EconEmployee)
VAR __allN = COUNTROWS(__all) + 0
VAR __a = SUMX(__people, EconEmployee[revenueAttributedFte]) + 0
VAR __allA = SUMX(__all, EconEmployee[revenueAttributedFte]) + 0
VAR __base = SUMX(__people, EconEmployee[basePay]) + 0
VAR __bonus = SUMX(__people, EconEmployee[bonus]) + 0
VAR __benefits = SUMX(__people, EconEmployee[benefitsCost]) + 0
VAR __annualPay = __base + __bonus
VAR __rewards = SUMX(__people, EconEmployee[totalRewards]) + 0
VAR __allPay = SUMX(__all, EconEmployee[basePay] + EconEmployee[bonus]) + 0
VAR __allBenefits = SUMX(__all, EconEmployee[benefitsCost]) + 0
VAR __months = COUNTROWS(FinancialPeriod) + 0
VAR __pay = (SUM(FinancialPeriod[payExpense]) + 0) * DIVIDE(__annualPay, __allPay)
VAR __ben = (SUM(FinancialPeriod[benefitsExpense]) + 0) * DIVIDE(__benefits, __allBenefits)
VAR __cost = __pay + __ben
VAR __nonpeople = (SUMX(FinancialPeriod, FinancialPeriod[operatingExpense] - FinancialPeriod[payExpense] - FinancialPeriod[benefitsExpense]) + 0) * DIVIDE(__n, __allN)
VAR __rev = (SUM(FinancialPeriod[revenue]) + 0) * DIVIDE(__a, __allA)
RETURN IF(__n < 10 || ISEMPTY(AsOf), BLANK(), __n)

Direct dependencies: None