Calculate measure based on Blocked and Null values

[Kaushik2020]

Dear All, 

I am reading data from Excel where we have below details. Is there a way to calculate Average and count based on the below mentioned logics ? 

ID	NAME	Salary	Designation	Q1-Rating	Q2-Rating	Q3-Rating	Q4-Rating	Yearly Average Rating	Count
1	A	10000	Tester	Blocked	Blocked	5	4	calculate based on Q3 and Q4	Count of Quarters where we have a data
2	B	20000	Developer	3	Blocked	Blocked	4	Calculate based on Q1 and Q4	Count of Quarters where we have a data
3	C	15000	Lead	3	5	4	4	Calculate based on all quarters	Count of Quarters where we have a data
4	D	20000	Manager	5	5	Blocked	Blocked	Calculate based on Q1 and Q2	Count of Quarters where we have a data

[Chanty4u]

Hi 

What is your expected output 

[Kaushik2020]

thanks for your reply. Please refer the last 2 columns for the same. Feel free to revert in case anything.