How can I incorperate the Business ratings into the overall score?

Question

The DAX below is calculating the overall ratings properly. However, when attempting to break the ratings out by function (IT and Business), the Business ratings are not being captured. Please find the screen shots below.

The first screenshot is calculating the IT scores properly but not the Business.

The second screenshot is how the particular section that contains the Business ratings should be calculating but only appears properly graphing only that section.

Final Averages =
var m = VALUES('Table'[Categories])
var p = if("Customer Experience" IN m, 1, 0)
var q = if("Operational Management" IN m, 1,0)
var r = if("Resource Management" IN m, 1, 0)
var x = p&q&r
return
IF(x="000",[Q2 Avg],IF(x="001",[AveResMgt],IF(x="010",[AveOpeMgt],IF(x="011",([Q5 Avg]+[Q6 Avg]+[Q7 Avg]+[Q8 Avg]+[Q9 Avg]+[Q10 Avg]+[Q11 Avg]+[Q12 Avg]+[Q13 Avg]+[Q14 Avg])/10,IF(x="100",[AveCustExp],IF(x="101",([Q1 Avg]+[Q2 Avg]+[Q3 AVG]+[Q4 Avg]+[Q10 Avg]+[Q11 Avg]+[Q12 Avg]+[Q13 Avg]+[Q4 Avg])/9,IF(x="110",([Q1 Avg]+[Q2 Avg]+[Q3 Avg]+[Q4 Avg]+[Q5 Avg]+[Q6 Avg]+[Q7 Avg]+[Q8 Avg]+[Q9 Avg])/9,IF(x="111",[Average2]))))))))