New Measure for Running Total from Measure Output

[isam2003]

Hello:

I have a DAX measure that results in the maximum of available quarterly sums in each fiscal (or calendar as per user choice) year.

    VAR __Type = MAX('Year_Type'[Year_Type])

    VAR __Year = MAX('Years'[Year])

    VAR __Result =

        IF(

            __Type = "Fiscal",

           

            MAXX(FILTER('Data_Q', [FYear] = __Year),[Value]),

            MAXX(FILTER('Data_Q', [CYear] = __Year),[Value])

        )

RETURN  

    __Result

I would like to add another measure that determines the MAX value over available quarters in a year (fiscal or calendar) for each country and returns the SUM.  For eg. the result would be 45 for the following table. 

Country	Q1 FY23	Q2 FY23	Greater?
A	18	17	18
B	4	4	4
C	1		1
D	8	8	8
E	12	14	14
			45

I tried a number of running total solutions available on this forum but could not work my way out . Any guidance would be much appreciated.

Thanks in advance. 

[MohammadLoran25]

Hi @isam2003 ,

Please share a sample data including your data model.