Total of a 3 Month Rolling Total Measure

[vflorente]

Hi,

I have a measure that calculates a 3 month rolling total (Annualized Activity Count).

Annualize Activity Count = CALCULATE(Sum(SVRIVR4[Annualize Rate]), DATESINPERIOD('Calendar'[Date], LASTDATE('Calendar'[Date]), -3, MONTH))

On a table the data reflects by the month

Is there a way to have the Grand Total show a total of 584?

or at least when the measure is put on a card it will display the total of 584?

Thanks!

[v-yangliu-msft · Accepted solution]

Hi  @vflorente ,

You can use the HASONEVALUE() function to fix the Total incorrect.

Here are the steps you can follow：

1. Create measure.

Total_Annualize Activity Count =
var _table=SUMMARIZE('Calendar','Calendar'[Date],"_value",[Annualize Activity Count])
return
IF(HASONEVALUE('Calendar'[Date]),[Annualize Activity Count],SUMX(_table,[_value]))

2. Result:

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

[Ashish_Mathur]

Hi,

Assuming the Year and Month name fields have been dragged from the Calendar Table, write this measure:

AAC final =SUMX(VALUES('Calendar'[Month name]),[Annualised Activity Count])

Hope this helps.