Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

MAA not summing correctly

Hi all,   I'm trying to make a moving annual average (over 13 periods) of incidents, however my MAA keeps under reporting. Here is my MAA measure:   MAA Incident Count = IF([Count_periods_prese...
Need Help
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

Anonymous , Try measure like

 

MAA Incident Count =
Sumx(Values('Financial Year & Period Data'[Financial Year/Period]) , IF([Count_periods_present] = 13,
CALCULATE (DISTINCTCOUNT('AttributionEvents_v1 1 0_Eastern'[Incident Number]),
FILTER(
ALL('Financial Year & Period Data'),
'Financial Year & Period Data'[Index] >= MAX('Financial Year & Period Data'[Index]) -12
&& 'Financial Year & Period Data'[Index] <= MAX('Financial Year & Period Data'[Index])
))/13))

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi amitchandak, unfortunately that still returns the same values as before, 52.08 for the first 13 periods.

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    HI Anonymous,

    Perhaps you can take a look at Greg's blog of measure total issue if helps:

    Measure Totals, The Final Word  

    Regards,
    Xiaoxin Sheng