How can I sum the max value per ID and group it by month?

[m_iago]

Hello,

I have a data similar to the following:

I need to find, using DAX, the GWperMonth. For that, I take the Max Value per ShipID from the column [GWperID] and sum the values from each month.

For that case, the Max Value for AB1 is 76, ABC2 is 70 and so on.

I've tried the following, without success:

GWperMonth = CALCULATE(SUMX(SUMARIZE("TableName", [ShipID], "MaxGW", MAX([GWperID])), "MaxGW"), ALLEXCEPT("TableName", [YearMonth]))

What am I doing wrong?

[some_bih]

Hi @m_iago your example set " AB1 is 76, ABC2 is 70", you need to get column for this group as there are other group starting with AB*.

It is not clear to do you want first max per group (which is unclear how to get as other group start with AB*) and sum it or you just need sum per group