"userelationship"
1 Topic
Exits of New Hires | Survival % of New Hires
Hello, I’m trying to count the number of new hires who exited during a given period. My total “New Hire Exits” measure works correctly when displayed in a card. However, when I use month name in a visual, the totals by month are not showing correctly. Please help me figure out why this isn’t working as intended? Thank you! Exits From New Hires = VAR PeriodStart = MIN('Calendar'[Date]) VAR PeriodEnd = MAX('Calendar'[Date]) RETURN CALCULATE( COUNTROWS(Employment), -- Must be a new hire in the period Employment[Hire Date] >= PeriodStart, Employment[Hire Date] <= PeriodEnd, -- Terminated within the period Employment[Termination Date] >= PeriodStart, Employment[Termination Date] <= PeriodEnd, CROSSFILTER('Calendar'[Date], Employment[Hire Date], None) ) Here's my new hires and exits total (regardless of whether they are hired or not within the period) for more context: Exits = CALCULATE( COUNTROWS(Employment), USERELATIONSHIP(Employment[Termination Date], Calendar[Date]), Employment[Termination Date] <> BLANK() ) New Hires = CALCULATE( COUNT(Employment[Employment Key]), ALL('Calendar'), // Must be hired ON or BEFORE the end of the period && ON or AFTER the start of the period (Employment[Hire Date] >= MIN('Calendar'[Date]) && Employment[Hire Date] <= MAX('Calendar'[Date])))Solved1.3KViews0likes7Comments