Calculate average from text column using month as base.

[zubairs]

I have a report from HR that has the ID for each employee.

In order to get the total number of HC, I am taking the count of employee ID. This works fine when I'm applying filter for a one month.

The problem occurs when I'm selecting multiple months because the count measure adds both months. Whereas, I want it to get the average of the two months.

Any suggesstions?

[amitchandak · Accepted solution]

@zubairs , You have to try a measure like

averageX(values(Date[Month]), [Count of employee])