How to get the MAX of a SUM GROUP BY

[arimoldi]

Hi,

I would like to get the MAX of a SUM grouped by some columns, something like:

MAX of (SUM of amount GROUP BY column a, column b)

so the MAX should be related not the single amounts but to the sum of the amounts grouped by column a, column b.

Thanks,

Andrea

[barritown · Accepted solution]

Hi @arimoldi,

You could solve your problem with a measure below.

The 1st step is to create a summarized table, the 2nd one - apply MAXX to it.

In plain text:

Max of Sums = 
VAR _tbl = SUMMARIZE ( Data, [Name], [Month], "Sum of Values", CALCULATE ( SUM (Data[Value] ) ) )
RETURN MAXX ( _tbl, [Sum of Values] )

Best Regards,

Alexander

My YouTube vlog in English

My YouTube vlog in Russian