Forum Discussion

Danny-Happy's avatar
Danny-Happy
Icon for Helper I rankHelper I
6 years ago
Solved

Calculate average FTE 2020

Hi All,   I like to calculate the average FTE per month for 2020. I already calculate the FTE per month with this DAX:   Count FTE = CALCULATE(    SUM( 'Dim - employees'[FTE] ) ,    FILTER( ...
Need Help
  • amitchandak's avatar
    amitchandak
    6 years ago

    Danny-Happy , Try like this and divide my month

    Count FTE =
    sumx(Values('Dim - time'[Month Year])
    CALCULATE(
    SUM( 'Dim - employees'[FTE] ) ,
    FILTER('Dim - employees '[date hired] , 'Dim - employees '[date hired] <= MAX( 'Dim - time'[Day] )) ,
    FILTER('Dim - employees'[date leave] , OR( 'Dim - employees'[date leave]>= MIN( 'Dim - time'[Day] ) , ISBLANK( 'Dim - employees'[date leave] ))
    )
    ))

Anonymous's avatar
Anonymous
Not applicable
4 years ago

This is really useful, I am getting an error when using the first calculation for determining actual FTE over months = A circular dependency was detected: PBIPND_vwPosition_Private[SUM of FTE], PBIPND_vwPosition_Private[Column], PBIPND_vwPosition_Private[SUM of FTE].

 

Any suggestions would be greatly appreciated?