Get SUM of Maximum values by customer

[Anonymous]

Hi All,

I have an excel file with 3 columns: "Month", "Name" and "Quantity" as you can see below.

I've created a first measure to have the max value for each customer by month:

Max by customer = CALCULATE(MAX(Feuil1[Quantity]))

 Below is the result for the month "11":

That's great, but when I went a level up and displayed the values by month, I got the result below:

For the month 11 I got the maximun value 250.00 but what I need is to the the SUM of each max value for each customer, which will be : 250.00 + 172.40 + 120.80 + 110.20 + 78.10 + 25.60 = 757.10

How I can fix fix it ? and modify my measure to get the SUM of the maxinum values for each month ?

Below is how I diplay my data:

Thanks in advance 🙂

[Anonymous]

@jdbuchanan71 many thanks 🙂

[jdbuchanan71 · Accepted solution]

@Anonymous 

Give this a try.

Sum Max = SUMX ( VALUES ( YourTable[Name] ), [Max by customer] )

You will have to change the measure to match your table name.