DAX for last financial year total to be a fixed number

[brightlight]

Dear community, 
I have a fact table like the following:

Need a DAX to calculate Total of the Full Last Financial Year (July 2021 - June 2022), and make that number as a static one without being sliced in other tables, for example:

Thank you!

[Greg_Deckler]

@brightlight Probably should unpivot the date columns. Also, what does your date table look like?

[brightlight]

@Greg_Deckler The raw data is the ERP system connected through SQL server, so the layout of date column is not relevant perhaps? Date table is created with CALENDARAUTO. Already have the Qty measure in place being SUMX('Fact Table','Fact Table'[Qty])

[Greg_Deckler]

@brightlight Do you have a Fiscal Year column in your Date table?

[brightlight]

@Greg_Deckler Yes I do have the fiscal year column in Date table, see below: