Average Grand Total

[smtexcel]

Please help, what am I missing here. This is the closest I've gotten after many attempts.

Trying to get the average rev by quarter - the values highlighted yellow.

AvgRev = AVERAGEX(ADDCOLUMNS(SUMMARIZE(Project_Data,Fiscal_Slicers[Fiscal Qtr],Fiscal_Slicers[Fiscal Year]),"Test",CALCULATE(SUM(Project_Data[RevRecNull]))),[Test])

In [RevRecNull] I replaced all the 0s with null.

For some reason to get to the correct value, Q2 needs to be muliplied by 2, Q3 by 3, and Q4 by 4.

Any Idea why or how I can modify this measure to fix it????

 

[pjmorris]

not sure I can help rewrite the measure, but it occurs to me that the figures are correct. The average for Q4 is (29216976+21310252+22096956+29358456+19496687)/5 = 24295865, which is what your measure has returned. Why are they wrong?