Forum Discussion

Jorgast's avatar
Jorgast
Icon for Resolver II rankResolver 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
Jorgast's avatar
Jorgast
Icon for Resolver II rankResolver 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
Icon for Community Champion rankCommunity Champion
6 years ago

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

 

 

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