how to get YAGO data

[smeg]

I have a Metrics_Table with below data, having Agg_level  data for current year and last year as well with one day difference shown in red,green marked.For example (6/18/2023 and 6/17/2023.),(3/25/2023 and 3/26/2022),...  Also AO_Dates are not continuous the data is usually loaded weekly like 6/10/2023, then 6/17/2023,...

I am trying to get sum of dollars for yearago as  aggregate level and AO_date will be passed as pagelevel filter by user dynamically  and look at the dollars for those filters  year ago.

For example if they select AO_Date=6/17/2023 and Agglevel=12 then Dollarsyago should be $48.05+$11.9+$6.49(which is data as of  6/18/2022 as shown in below table)

is there a way to calculate year ago dollars so that AO_date and Agg_level can be passed dynamically .

I tried doing using below measure but it did not work.It is giving sum of dollars  for the whole table but i need it dynamically when user passes AO_Date and Agg_Level.

Dollars,YAgo = CALCULATE(SUM(Metrics_Table[$]),PARALLELPERIOD(Metrics_Table[AO_Date],-1,YEAR))

Can some one please help?

Thanks..