Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Incorrect Measure - FIX

Good morning

 

I need some assistance in obtaining a particular calculation. The calulation I need total days of unscheduled absence/ average FTE  over a reporting period. 

 

Current using the below DAX Measure and the FTE rolling average is based on months 

DIVIDE(
    SUM('Unscheduled Leave'[Actual Days]),
    [FTE Average rolling average]
)
 

Figures should be sitting around 14-15 days but the measure is producing numbers up towards 80, 90 and some in the hundreds. Help! 

1 Reply

  • amitchandak's avatar
    amitchandak
    Super User
    4 years ago

    Anonymous , I doubt the Avg measure or having Avg below for this calculation. Can you share the calculation for that.

     

    It should be period Avg not line level

     

    like Averagex(Values(Table[Emp ID]), [Meausre])

     

    or

    Averagex(Values(Table[Month Year]), [Meausre])