Bicycle.LLCSchedule a call

← Dashboard collection

Choose dashboard — Workforce Economics

people analytics dashboard

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 — 1 Summary

Selected page

1 Summary

DAX definitions

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

Allocated Pay Expense

EconEmployee · Financial


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) || __months = 0 || __allPay = 0 || __allBenefits = 0, BLANK(), __pay)

Direct dependencies: None

Allocated Revenue

EconEmployee · Financial


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) || __months = 0 || __allPay = 0 || __allBenefits = 0 || __allA = 0 || (__a > 0 && __a < 10), BLANK(), __rev)

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

Economics Sensitivity Text

EconEmployee · Report Views


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(), IF(ISBLANK([Human Capital ROI]) || ISBLANK([Pay Sensitivity ROI]), BLANK(), "ILLUSTRATIVE: ROI " & FORMAT([Human Capital ROI], "0.00", "en-US") & "x; +10% pay ROI " & FORMAT([Pay Sensitivity ROI], "0.00", "en-US") & "x. Revenue, benefits and nonpeople expense held constant; no causal claim."))

Direct dependencies: Human Capital ROI, Pay Sensitivity ROI

Human Capital Cost Factor

EconEmployee · Economics


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) || __months = 0 || __allPay = 0 || __allBenefits = 0, BLANK(), DIVIDE(__cost, __n))

Direct dependencies: None

Human Capital ROI

EconEmployee · Economics


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) || __months = 0 || __allPay = 0 || __allBenefits = 0 || __allA = 0 || (__a > 0 && __a < 10), BLANK(), DIVIDE(__rev - __nonpeople, __cost))

Direct dependencies: None

Pay Sensitivity ROI

EconEmployee · Sensitivity


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) || __months = 0 || __allPay = 0 || __allBenefits = 0 || __allA = 0 || (__a > 0 && __a < 10), BLANK(), DIVIDE(__rev - __nonpeople, __cost + 0.10 * __pay))

Direct dependencies: None

Revenue per FTE

EconEmployee · Economics


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) || __months = 0 || __allPay = 0 || __allBenefits = 0 || __allA = 0 || (__a > 0 && __a < 10), BLANK(), DIVIDE(__rev, __a))

Direct dependencies: None