Averages to include blank rows

[MuthalibAbdul]

Hello Community,

So to start with, I have a table with my employees and list of customers they dealt with on a day to day basis. I am able to get the count by day/week/month/quarter/year in a perfect way by having a Calender table and linking these two tables. 

Problem is when I calculate averages per month or per week, it does not include rows where 0 customers were seen. Hence the averages are higher than they should be. 

I have attached the dax below (created by quick measure) where I calculate the average per month and week. I have an interactive  dashboard and I also need the values to change when a selection has been made. Like a particular employee etc. 

Your help would be appreciated.

Update:

I just solved this by creating two measures, one for distinct count of week and other toal encounters and also tried your way. The results for both the method are same. However, your method is easy and quick. 

The next issue I have is few employees started in the middle of the year, say June. Both the methods mentioned above is calculating all the weeks since Jan. 

How do I set a conditional saying if any week has an input (basically means new employee joined), then start doing rolling average from that point forward. 

I am also anticipating another issue where an employee left, so provide a condition for a stop for particular employees. 

[Greg_Deckler · Accepted solution]

@MuthalibAbdul Try adding + 0 right after your CALCULATE statement

[MuthalibAbdul]

Perfect, I just solved this by creating two measures, one for distinct count of week and other toal encounters and also tried your way. The results for both the method are same. However, your method is easy and quick. 

The next issue I have is few employees started in the middle of the year, say June. Both the methods mentioned above is calculating all the weeks since Jan. 

How do I set a conditional saying if any week has an input (basically means new employee joined), then start doing rolling average from that point forward. 

I am also anticipating another issue where an employee left, so provide a condition for a stop for particular employees.