Forum Discussion

Jorgast's avatar
Jorgast
Resolver II
6 years ago
Solved

Annual Average based on Distinct Count

Hi-Power BI community,   I need your help. I am trying to look at the average number of people I had for 2019. So far, I was able to get the Distinct Count of their ID by day. When I compare the Av...
Need Help
vanessafvg's avatar
vanessafvg
Community Champion
6 years ago

is this what you looking for?

  • Jorgast's avatar
    Jorgast
    Resolver II
    6 years ago

    vanessafvg 

    Yes

    Doing an average of a distinct count is not working for me. What i want to do is get the average count for the year. 

    • vanessafvg's avatar
      vanessafvg
      Community Champion
      6 years ago

      ok unless im missing something, would this not work for you?  

       

       

      avg of headcount 2 = AVERAGE(headount[Headcount])