SUM of MAX Values GROUPED BY Month

[raksone]

Hello,

I am trying to sum all max values from Type column by number of Month, but I do not where to include the latter.

How can I make this formula to sum only values of type and also for same month, and only then get the max of values?

=SUMX (
FILTER (
GROUPBY (
'Table114',
'Table114'[Type],
"Max", MAXX ( CURRENTGROUP (), 'Table114'[Charge3] ),
"Count", COUNTX ( CURRENTGROUP (), 1 )
),
[Count] >= 1
),
[Max]
)

[amitchandak · Accepted solution]

@raksone , Try

=SUMX (
FILTER (
GROUPBY (
'Table114',
'Table114'[Type],
'Table114'[Month Year],
"Max", MAXX ( CURRENTGROUP (), 'Table114'[Charge3] ),
"Count", COUNTX ( CURRENTGROUP (), 1 )
),
[Count] >= 1
),
[Max]
)

or

=SUMX (
FILTER (
Summarize (
'Table114',
'Table114'[Type],
'Table114'[Month Year],
"Max", MAXX ( CURRENTGROUP (), 'Table114'[Charge3] ),
"Count", COUNTX ( CURRENTGROUP (), 1 )
),
[Count] >= 1
),
[Max]
)

If this does not help
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.