Rolling Total not calculating correctly

[Anonymous]

Hello all, 

I have an issue where I am trying to calculate the rolling sum for monthly actuals

Actuals Month running total in FY Date = 
CALCULATE(
	SUM('iFiscal Unpivoted'[Actuals Month]),
	FILTER(
		ALLSELECTED('iFiscal Unpivoted'[FY Date]),
		ISONORAFTER('iFiscal Unpivoted'[FY Date], MAX('iFiscal Unpivoted'[FY Date]), DESC)
	)
)

 The following screenshot illustrates my issue.

Here is what the data looks like in my model. Please note that some Actuals have repeated dates as they correspond with different expenses.

Can someone please help me find the right configuration to correctly calculate the rolling sum?

[Greg_Deckler · Accepted solution]

@Anonymous Better Running Total - Microsoft Power BI Community

[Anonymous]

Thank you for the reply. It has fixed the sum for some of my data but sometimes I am running into this: 

Any idea how this might have happened? 

[Greg_Deckler]

@Anonymous Extremely hard to say without the data.

[Anonymous]

haha, found the issue. need to do more readings on relationships.

thanks for the help!