Sum of max values

[vbis]

Hello.

I want to get the sum of max values per country, per customer, per product. 

Here is an example where revenue is the max of values 

country	customer	product	quarter	revenue
Germany	A	beverages	Q1	1000
Germany	A	food	Q1	1000
Germany	A	food	Q2	1500
Germany	B	beverages	Q1	1200
Germany	B	food	Q2	1700
Netherlands	A	beverages	Q2	1800
Netherlands	B	food	Q2	2000

[Arul]

@vbis ,

Check whether this is heling or not?

Max Sum = 
VAR _tempTable = SUMMARIZE(
    ALLEXCEPT('Table ',
    'Table'[country],
    'Table '[customer],
    'Table '[product]),
    "@Max sum",MAX('Table'[revenue]))
VAR _result = SUMX(_tempTable,[@Max sum])
RETURN _result

Thanks,

Arul