Hi @Abhi1306,
Thank you for reaching out to the Microsoft fabric community forum. Thank you @bhanu_gautam, for your inputs on this issue.
I understand you're facing issues with mismatched Active Head Count between Power BI and Excel. This often comes down to how the logic is implemented for counting active employees over time.
You might find this Microsoft blog helpful. It covers how to correctly calculate total headcount without cumulative errors and gives good DAX patterns to follow:
How to calculate total headcount for each year, not cumulative
Check the Data Source: Verify that the data for the KPI card and pie chart is being pulled from the correct source, ensuring no filters or limitations are applied during querying. Data Integrity: Review the Excel data for any missing or incorrect records, such as duplicates or empty rows that could affect the count.
Date Range: Confirm that the date range for the headcount data is consistent between the Excel data and the visualizations, as discrepancies can occur if different timeframes are used. Aggregation Method: Examine the aggregation method for the headcount, as differences in counting methods (sum, distinct count, etc.) can cause variations between the raw data and visual representations.
Data Load Issues: Ensure there are no issues with data loading that could result in missed or unaccounted rows.
Recalculate or Refresh the Data: Refresh the dashboard or recalibrate the KPIs to ensure the data is current, as there may be cache issues or delays in updating. Filter or Grouping: Verify if any filters are applied to the charts that might exclude specific headcount groups, as this can lead to discrepancies.
For reference kindly go through the below link for better understanding:
HR Analytics - Active Employee, Hire and Termination - Microsoft Fabric Community
If this post helps, then please give us ‘Kudos’ and consider Accept it as a solution to help the other members find it more quickly.
Thank you for using Microsoft Community Forum.
