Sum of counts Previous+Current Value by Group

[RevD]

Here is the Sample i have. I have data by Quarters wanted to calculate (Current Quat Count + Previous Quat Count) / 2 which is working Good. My challenge is i want to display the sum of all the values for each category. Below is the Formula i am using 

Current Quat Count =COUNT(Sheet1[Index]) 

Previous = IF(HASONEVALUE(Sheet1[DateCustom]),

CALCULATE([Counts],VALUES(Sheet1[Category ]),DATEADD(Sheet1[DateCustom],-1,QUARTER))

,BLANK())

overallCounts = ([Counts]+[Previous]) / (2 - ISBLANK([Counts]) - ISBLANK([Previous]))

Here is what i want : 

1. Sum of counts from the above values by Category,  It should sum all the values displayed in Quarters . For Column B ,C 

2. Total : Sum of Values by Quarter * Weight  = Sum of Quarters in Each category = Sum  = For column d

below is the sample data 

Index	Category	DateCustom	Rating	WEIGHT
1	Food	1/1/2019	Good	0.4
2	Food	1/1/2019	Good	0.4
31	Food	1/1/2019	Bad	0.4
3	Food	1/1/2019	Verygood	0.4
4	Food	4/1/2019	Verygood	0.5
5	Food	4/1/2019	Verygood	0.5
6	Food	4/1/2019	Bad	0.5
7	Food	4/1/2019	Bad	0.5
8	Food	7/1/2019	Verygood	0.3
9	Food	7/1/2019	verygood	0.3
10	Food	7/1/2019	Bad	0.3
11	Food	7/1/2019	Bad	0.3
12	Food	7/1/2019	Bad	0.3
13	Cloths	1/1/2019	Good	0.4
14	Cloths	1/1/2019	Good	0.4
15	Cloths	1/1/2019	Bad	0.4
16	Cloths	1/1/2019	Verygood	0.4
17	Cloths	1/1/2019	Verygood	0.4
18	Cloths	4/1/2019	Good	0.5
19	Cloths	4/1/2019	Good	0.5
20	Cloths	4/1/2019	Good	0.5
21	Cloths	4/1/2019	Verygood	0.5
22	Cloths	4/1/2019	Verygood	0.5
23	Cloths	4/1/2019	Bad	0.5
24	Cloths	4/1/2019	Bad	0.5
25	Cloths	4/1/2019	Bad	0.5
26	Cloths	7/1/2019	Verygood	0.3
27	Cloths	7/1/2019	Verygood	0.3
28	Cloths	7/1/2019	Bad	0.3
29	Cloths	7/1/2019	Bad	0.3
30	Cloths	7/1/2019	Bad	0.3

Thanks in Advance

[v-chuncz-msft]

@RevD 

You may use ISINSCOPE to detect the level and SUMX to get the total.

https://www.sqlbi.com/articles/obtaining-accurate-totals-in-dax/

[RevD]

I was able to achive this 

2. Total : Sum of Values by Quarter * Weight  = Sum of Quarters in Each category = Sum  = For column d

But i am not able to get this, Can you provide Dax 

_Count = CALCULATE(COUNTX(Sheet1,Sheet1[Index]),FILTER(Sheet1,NOT(ISBLANK(Sheet1[Index]))))

_PreviousCounts = IF(HASONEVALUE(Sheet1[DateCustom]),

CALCULATE([_Count],VALUES(Sheet1[Category]),DATEADD(Sheet1[DateCustom],-1,QUARTER))

,BLANK())

_AccuracyRollingAvg = ([_Count ]+[_PreviousCounts ] )/

(2-ISBLANK([_Count ])-ISBLANK([_PreviousCounts ]))

Currently i use this _AccuracyRollingAvg to display by Quarters for each Category and it works good. In the new table i want to display sum of _AccuracyRollingAvg by Category  like below. Is it possible to use _AccuracyRollingAvg in Sumx