Average excluding blank cells

Dear all,

We are running an Employee Satisfaction Survey in our company but I am having hard time to find the average scores due to the blank cells in data cells, therefore looking for your valuable input.

I have a dataset like this:

Question 1 and Question 2, for example, belong to the "Leadership index" group. Therefore, in order to find the average score per manager for the "Leadership index", I created the following measure:

Leadership index = (AVERAGE(Sheet1[Question 1])+AVERAGE(Sheet1[Question 2])/2)

However, it results in incorrect scores as following, I believe because the measure does not exclude the blank cells while calculating the measure:

Do you guys have any ideas on how to exclude the blank values while calcualating the measure so that I get the correct results?

Thanks for your support!

Ugur Gulluev