How to filter table on a calculated balance sheet using a Max date?

I have transformed my data source into income statement (movement from previous quarter starting each FY at zero[July in my case]) and balance sheet and cash flow being the cumulative balance as per my data source.

I am trying to get some ratios to work that use both income  and balance sheet items (such as return on assets).  I have a date slider so the users can select a period (between two values).  All the cumulative items (income statement) are OK, but when I retreive my assets and the like by default PowerBi summates the values for each quarter, so it overstates the assets values. 

I would like to be able to use the Max Date value for assets instead of the sum of them.

I am using the following DAX for to retreive the Assets value.  (CALCULATE('QAFP_Data'[Actual],'CoA_Full'[Acct_Type Level 1] = "Assets" ) .  I have tried to add a date filter using Max Date, but no joy.

Any suggestions would be greatly appreciated.