Find max for each group of rows

[gvlado]

Hello. 
I have the problem - how to get column 3 according to Column 1, 2, and the value column (table is below)
For the locations and names, I have to detect the max value that I will use in further calculations 
Not sure can it be done in M Query or DAX? 

Thanks

Nice hot greeting from Croatia

[JamesFr06 · Accepted solution]

HI

please find a solution

Maxval = calculate(max(Feuil3[Value]),ALLEXCEPT(Feuil3,Feuil3[a],Feuil3[b]))

[gvlado]

Thanks a lot
Sometimes I cant' find so simple solutions 
That is why this community is valuable - quick and simple Q&A
You earned coffee from me
Thanks once again

[johnt75]

You can create a measure like 

Max Value for Location = CALCULATE( MAX('Table'[Value]), ALLEXCEPT('Table', 'Table'[Column1]))