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...
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]
)
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]
)