Forum Discussion

VI_Migration's avatar
VI_Migration
Silver Contributor
Nov 29, 2022

Measured Employee Count is Greater than Licensed Employees

Working with a customer and we recently noticed that the Measured Employee count being shown on PowerBI reports is significantly greater than the number of licensed employees.   Has anyone else obse...
lorinamuca's avatar
lorinamuca
Copper Contributor
Dec 01, 2022

Hello Kevin,

It's confusing i know but the number of measured employees you are looking ate the power bi file it's not the same as the measured employees on WPA.  Meaning that the measured employees on the pbi file it's the distinct count of PersonId of the csv file of the organizational data uploaded in WPA. Instead, the measured employees you see in WPA are actually the Viva Insights licensed employees.

Thank you

  • VI_Migration's avatar
    VI_Migration
    Silver Contributor
    Dec 01, 2022

    Thanks.  I may not have explained the situation well enough. 

    We have approximately 3,900 licensed employees and we are seeing 6,000+ unique person ID's in the output of our analysis with associated measures.  So it appears that we are measuring activity for more employees than we have assigned licenses to, which doesn't seem correct.

    • lorinamuca's avatar
      lorinamuca
      Copper Contributor
      Dec 02, 2022

      A best practice that MS suggests is to always have the same Viva Insights licensed employees inside the .csv file of the organizational data. MAybe you should try and "clean up" the .csv file.

      Thank you

      • VI_Migration's avatar
        VI_Migration
        Silver Contributor
        Dec 02, 2022

        Hi Imuca,

        Thanks again for your input.  The actual best practice is to include all employees in the org data file, even employees who are not licensed (i.e., measured).  Please see https://learn.microsoft.com/en-us/viva/insights/advanced/admin/prepare-org-data#employees-to-include

        Kevin

Resources