Forum Discussion

Luuk_J's avatar
Luuk_J
Frequent Visitor
5 years ago

Average measure (over time)

Hi everyone,   I have a question regarding making an average over time measure in Power BI.   Ultimately, I need to average the number of FTE (full-time equivalent) during a certain period in tim...
Need Help
v-alq-msft's avatar
v-alq-msft
Icon for Community Support rankCommunity Support
5 years ago

Hi, Luuk_J 

 

You may modify the measure as below.

 

AVG FTE divide = 
VAR avs = 
CALCULATE(
    SUM ( 'Fact'[FTE] ),
    ALLEXCEPT('Fact','Fact'[Employee])
)
VAR dis =
  CALCULATE ( DISTINCTCOUNT ( 'Fact'[Datekey]), ALLSELECTED(  'Fact'))
  RETURN
  DIVIDE(avs,dis)

 

 

Result:

 

Best Regards

Allan

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • Luuk_J's avatar
    Luuk_J
    Frequent Visitor
    5 years ago
    Hi Allan, Thank you very much for your suggestion/answer. Although your solution works in the sample file, it unfortunately does not in the original PBIX file I am working with. It may have to do with the bigger number of dimensions I am working with in the original file, but I have to look into it. I am planning to do that later this week and I will post an update afterwards. Kind regards, Luuk