Calculate Average of Monthly Calculations

[sgv2000]

I have a calculated measure that looks like this.  

DII Demand = sum(vw_superclassadetails_all_currentweek[JabilInventoryDollars])/( sum(vw_superclassadetails_all_currentweek[QuarterlyDemandDollars]) / 91)

I want to get the value of this at the date level, we only have one da per week, then average the values for the quarter.  Quarter is determined by another field in the data because we don't use calendar quarters.  I tried to explain the calculation below.  I removed many columns to simplify the calculation.  I don't think summary tables will work because we have filters on the report that need to change these values as well.  If you create a summary table without those columns, then it will not react and if you include them then it will not calculate correctly.  I would like to find a way to do this with DAX.

1	B	C	D	E	F	G	H
2	Date	Quarter	Site	Inventory	Demand	DII Per Date
3	11/26/2018	2	A	3000	4000
4	11/26/2018	2	B	3000	10000	39	=SUM(E3:E4)/(SUM(F3:F4)/91)
5	12/3/2018	1	A	1000	5000
6	12/3/2018	1	B	1000	1000	30.33333
7	12/10/2018	1	A	2000	8000
8	12/10/2018	1	B	2000	2000	36.4
9	12/17/2018	1	A	3000	4000
10	12/17/2018	1	B	3000	3000	78
11	12/24/2018	1	A	1000	1000
12	12/24/2018	1	B	1000	4000	36.4
13	12/31/2018	1	A	2000	6000
14	12/31/2018	1	B	2000	4000	36.4
15	1/7/2019	1	A	3000	10000
16	1/7/2019	1	B	3000	5000	36.4
17	1/14/2019	1	A	1000	8000
18	1/14/2019	1	B	1000	5000	14
19	1/21/2019	1	A	2000	3000
20	1/21/2019	1	B	2000	6000	40.44444
21	1/28/2019	1	A	3000	5000
22	1/28/2019	1	B	3000	6000	49.63636
23	2/4/2019	1	A	1000	6000
24	2/4/2019	1	B	1000	8000	13
25	2/11/2019	1	A	2000	2000
26	2/11/2019	1	B	2000	8000	36.4
27						37.03765	=AVERAGE(G6:G26)

[Anonymous]

Hi @sgv2000 ;

For grouping values by date follow the below steps

create a column for sum inventory values

Column1 = CALCULATE(SUM(Table3[Inventory]);FILTER(Table3;Table3[Date]=EARLIER(Table3[Date])))
create another column for sum Demandvalues

Column2 = CALCULATE(SUM(Table3[Demand]);FILTER(Table3;Table3[Date]=EARLIER(Table3[Date])))

Now you can make the calculation you want.
Column3=column1/(column2/91)

Actually i couldn't understant for Dll Per Date column logic for which row should be empty.
For your example we can use Site column. For site values when it was A then null. We can create a column for this.

[sgv2000]

I am sorry, it is difficult to explain the calculation.  I can get the DII to work fine.  The measure I have works.  I now need to make that measure group by date then average those values.  It is not simply doing the same DII calculation on the totals of the data.  It is averaging the daily totals.