Calculate a previous period Sum

[spartan27244]

As in the example on this page SAMEPERIODLASTYEAR function (DAX) - DAX | Microsoft Docs

= CALCULATE(SUM(ResellerSales_USD[SalesAmount_USD]), SAMEPERIODLASTYEAR(DateTime[DateKey]))

I too am trying to do the same, my measuer formula is as so

PrevPrdPlanPaid = CALCULATE(Sum(MedClaims[PlanPaid]), SAMEPERIODLASTYEAR(Dates[Date]))

However my visual always shows a blank, when it should show for example in 2019-FY 10,503,949.37 i.e. the 2018-FY value, etc. I know this seems point less but the number will be used to calculate a rate of change which is simple math once I can get the number. I have attached PBX file, well apparently I cannot attach a file so here is the onedrive link

https://mycatalyst-my.sharepoint.com/:u:/p/ltaylor23/ERyJGLMYHB9NsQO9pcEdlT4BYWfQrOR8-4VlIpYei0poqg?...

My data model is very simple, note the Date table is Marked as a Date Table.

[CNENFRNL]

For most seansoned DAX users, both cross filtering direction (bi-directions) in data model is time bomb rather than cure-all. At least for me, I rely on mono-directional relations in data model.

[spartan27244]

Looks like this works

PrevPlanPaid =

Var D = DATESBETWEEN(Dates[Date], DateAdd(firstdate(Dates[Date]), -1, year), DATEADD(LASTDATE(Dates[Date]), -1, YEAR))

return CALCULATE(Sum(MedClaims[PlanPaid]), REMOVEFILTERS(ReportPeriods), D)

[spartan27244]

By removing the bidirectional filter, none of the other visuals are calculated properly