Turnover over years

Sounds good. Would you want to use a Sankey chart visual for that? 

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information. Do not include anything that is unrelated to the issue or question.
Please show the expected outcome based on the sample data you provided.

Need help uploading data? https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

thanks for the Reply! here is an example of the data I have, what I need is to calculate the Turnover %

Hi mirmo ,

To calculate year-over-year turnover for key talent pools in Power BI, you need a table that includes at least EmployeeID, Year, and TalentPool. The goal is to determine how many employees remained in the same pool from one year to the next, such as how many employees in the HP category in 2024 are still in HP in 2025. This is a retention calculation. To get started, you can create a DAX measure called HP Retention that dynamically checks the selected year and compares it to the previous year.

HP Retention = 
VAR SelectedYear = MAX('Calendar'[Year])
VAR PreviousYear = SelectedYear - 1

VAR HP_LastYear = 
    FILTER(
        'TalentData',
        'TalentData'[Year] = PreviousYear &&
        'TalentData'[TalentPool] = "HP"
    )

VAR HP_ThisYear = 
    FILTER(
        'TalentData',
        'TalentData'[Year] = SelectedYear &&
        'TalentData'[TalentPool] = "HP"
    )

RETURN
CALCULATE(
    COUNTROWS(HP_LastYear),
    INTERSECT(
        SELECTCOLUMNS(HP_LastYear, "EmployeeID", 'TalentData'[EmployeeID]),
        SELECTCOLUMNS(HP_ThisYear, "EmployeeID", 'TalentData'[EmployeeID])
    )
)

To calculate the turnover, you can create another measure called HP Turnover by subtracting the retained count from the total HP population in the previous year.

HP Turnover = 
VAR SelectedYear = MAX('Calendar'[Year])
VAR PreviousYear = SelectedYear - 1

VAR Total_HP_LastYear = 
    CALCULATE(
        COUNTROWS('TalentData'),
        'TalentData'[Year] = PreviousYear,
        'TalentData'[TalentPool] = "HP"
    )

RETURN
Total_HP_LastYear - [HP Retention]

This setup will allow your report to dynamically show the number of employees retained or lost from the HP pool, depending on the year selected in the slicer. You can replicate this logic for other talent pool categories by changing "HP" to the desired pool or making it a variable based on user selection.

Best regards,

I get an error: