Forum Discussion

airwater's avatar
airwater
Regular Visitor
4 years ago
Solved

Calculating average employee count

I have created a data model of list of staff reports (x12) converted into one data table. So an employee who has worked for 12 months will appear in the report 12 times.   I have created a new meas...
POWER BI Dax rules
  • amitchandak's avatar
    amitchandak
    4 years ago

    airwater , This already of month,

    AVERAGEX(
    KEEPFILTERS(VALUES('Date Table'[Month])),
    CALCULATE(COUNTROWS(Headcount),Headcount[Assignment Category] = "Permanent"))

     

     

    Not sure on the need to divide by 12

     

    If this does not help
    Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

     

    refer

    Average of Rolling, Average of Snapshots: https://youtu.be/_pZRdLAJxxA

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

airwater , This already of month,

AVERAGEX(
KEEPFILTERS(VALUES('Date Table'[Month])),
CALCULATE(COUNTROWS(Headcount),Headcount[Assignment Category] = "Permanent"))

 

 

Not sure on the need to divide by 12

 

If this does not help
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

 

refer

Average of Rolling, Average of Snapshots: https://youtu.be/_pZRdLAJxxA