New Measure for Running Total from Measure Output

Question

Hello:&nbsp;I have a DAX measure that results in the maximum of available quarterly sums in each fiscal (or calendar as per user choice) year.&nbsp; &nbsp; VAR __Type = MAX('Year_Type'[Year_Type])&nbsp; &nbsp; VAR __Year = MAX('Years'[Year])&nbsp; &nbsp; VAR __Result = &nbsp; &nbsp; &nbsp; &nbsp; IF(&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; __Type = "Fiscal",&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; MAXX(FILTER('Data_Q', [FYear] = __Year),[Value]),&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; MAXX(FILTER('Data_Q', [CYear] = __Year),[Value])&nbsp; &nbsp; &nbsp; &nbsp; )RETURN &nbsp;&nbsp; &nbsp; __ResultI 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.&nbsp; For eg. the result would be 45 for the following table.&nbsp;CountryQ1 FY23Q2 FY23Greater?A181718B444C1&nbsp;1D888E121414&nbsp;&nbsp;&nbsp;45I 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.&nbsp;

mohammadloran25 · Answer

Hi&nbsp;isam2003&nbsp;,Please share a sample data including your data model.

Forum Discussion

New Measure for Running Total from Measure Output

1 Reply

Related content

Measure

DAX Measure

Path Measure

% of total measure

Count Measure

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