Matrix Row Wise sum

Hi Team,

I need an urgent support in a dax query for the matrix in bi. I have one requirement where i need to show the availability of the resources. Suppose there are 10 Ops manager and 50 Reporting manager in an organization and under those 50 reporting managers 200 people are there distributed accordingly. So i am creating a matrix in which i want to show the avaiable resource under ops and reporting manager. For example John as a reporting manager has 4 employees so i want to show there availability in a matrix, for example- 

I have one query (Total Demand) which is calculating the demand/occupancy and for calculating the capacity i am doing 1-[Total Demand] so i am getting capacity but the probelm is when it comes to individual availability it's showing the proper number as the above table is showing only problem is when you will see for John for the month of Jan-24 it's showing -1, and total Demand for Jan-24 is 2 and as per query it's giving me -1 but i need the sum of 0+0.2+0.8+1 = 2. Please suggest some query which can give me the desired output. Please team sorry for long description, it's urgent please help me out.