Measure for Fiscal Year Totals

[IamTDR]

See above for a Date table I built within my report.  I am trying to do a measure to calculate total units by fiscal year 2022 and 2021.
This measure works but in doing so I would be required to edit the report yearly. 

CY Units = CALCULATE(SUM(SalesSummary[Units]),FILTER('Date','Date'[Fiscal Year]=2022))

Any idea how to make this dynamic?  Tried this measure but it returned the total for ALL fiscal years not just 2022.

CY Units = CALCULATE(SUM(SalesSummary[Units]),FILTER('Date',MAX('Date'[Fiscal Year])))

Thanks in advance!

[IamTDR · Accepted solution]

Thanks for replies.
I think I just got this to work on my own. See below for CY and PY measures. I didnt have to create another table either.

CY Units = CALCULATE(SUM(SalesSummary[Units]),FILTER('Date','Date'[Fiscal Year]=MAX('Date'[Fiscal Year])))
PY Units = CALCULATE(SUM(SalesSummary[Units]),FILTER('Date','Date'[Fiscal Year]=MAX('Date'[Fiscal Year])-1))

[tackytechtom]

Hi @IamTDR ,

Does it work with this measure?

CY Units = 
VAR _maxYear = MAX ('Date'[Fiscal Year] )
RETURN
CALCULATE ( 
    SUM ( SalesSummary[Units] ),
    FILTER ( 'Date', 
     'Date' [Fiscal Year] = _maxYear
    )
) 

/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/

[IamTDR]

Yup. Seems this measure works as well. Thanks 

[PijushRoy]

Hi @IamTDR 

Please try this
Create New Table = DISTINCT('Calender'[Fiscal Year])
Make relationship witn your calender table Fiscal Year to Fiscal Year
Now do measure
= VAR _FY = SELECTEDVALUE('New Table'[Fiscal Year])
RETURN
CALCULATE(SUM(SalesSummary[Units]),_FY)