MAXX with SUMAMRIZE or GROUPBY?

[mrothschild]

I have data similar to the following:

While I'm able to get a Location_Measure max Number by Location, I don't quite understand the SUMMARIZE or GROUPBY function with MAXX to get the maximum number by City or Country. 

Desired output is a City_Measure that equals 130 and Country_Measure that equals 180

Country	City	Location	Number
USA	NY	A	10
USA	LA	B	65
USA	LA	C	65
UK	London	D	60
UK	London	E	60
UK	Brighton	F	60

[mrothschild]

@vanessafvg,

Thanks so much.  The output will be used in a measure or a card.  This is exactly what I needed!

[vanessafvg · Accepted solution]

how do you want to use this data?

something like this could work but depending on how you using it

City_Measure = MAXX(DISTINCT('Table'[City]), CALCULATE(SUM('Table'[Number]))))

Country_Measure = MAXX(DISTINCT('Table'[Country]), CALCULATE(SUM('Table'[Number])))