Percent distinct values year over year

KMEAGHER You can create a measure that calculates the percentage of Research IDs retained from one year to the next. 

Create a Calculated Column for Year: Year = YEAR([School Year])

 

Create a Measure for Retained Teachers:

RetainedTeachers =
VAR CurrentYear = MAX('Table'[Year])
RETURN
CALCULATE(
COUNTROWS('Table'),
FILTER(
'Table',
'Table'[Year] = CurrentYear &&
'Table'[Research Id] IN
CALCULATETABLE(
VALUES('Table'[Research Id]),
'Table'[Year] = CurrentYear - 1
)
)
)

 

Create a Measure for Total Teachers in Previous Year:

TotalTeachersPreviousYear =
VAR CurrentYear = MAX('Table'[Year])
RETURN
CALCULATE(
COUNTROWS('Table'),
'Table'[Year] = CurrentYear - 1
)

 

Create the Turnover Rate Measure:

TurnoverRate =
DIVIDE(
[RetainedTeachers],
[TotalTeachersPreviousYear],
0
)

 

Use a line chart or any other suitable visualization to display the turnover rate over the years.