Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Calculated measure max by group

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 IDCustomer NameRevenue
1Microsoft50
1Microsoft60
2Microsoft100
2Microsoft110
Need Help
  • az38's avatar
    az38
    6 years ago

    Hi Anonymous 

    try a measure

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

1 Reply

  • az38's avatar
    az38
    Community Champion
    6 years ago

    Hi Anonymous 

    try a measure

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