Sum of Max Values by Customer

[Anonymous]

Hi all, I want to create a measure that sums the highest value, by customer. For example, the highest Count for Customer A is 30, and the highest for customer B is 100. I want to do 30+100 and have it as a measure. Any ideas?

Customer	Count
A	20
A	30
B	50
B	100

[Ashish_Mathur]

Hi,

Try these measures

Max value = MAX(Data[Count])

Total of max = SUMX(VALUES(Data[Customer]),[Max value])

Hope this helps.

[parry2k · Accepted solution]

@Anonymous try this measure, you answer suppose to be 130 = (A=30 and B= 100), you mentioned expected result to be 150

Max Sum = 
SUMX ( 
VALUES ( Table[Customer] ), 
CALCULATE( MAX ( Tabale[Count] ), 
ALLEXCEPT ( Table, Table[Customer] ) 
) 
)

 Would appreciate Kudos 🙂 if my solution helped.  Ask anything Power BI. Book appointment for a free consultancy at https://www.perytus.com