Calculated measure max by group

[Anonymous]

Hi all, I'm trying to add the Max of Revenue for each Customer ID together in a measure. For the data below, I'd like to add 60 (max for customer 1) and 110 (max for customer 2) to get 170.

Would anyone know how to do this? Thank you!

Customer ID	Customer Name	Revenue
1	Microsoft	50
1	Microsoft	60
2	Microsoft	100
2	Microsoft	110

[az38 · Accepted solution]

Hi @Anonymous 

try a measure

Measure = SUMX(
SUMMARIZE('Table', 'Table'[Customer ID], "MaxRevenue", MAX('Table'[Revenue])), 
[MaxRevenue]
)