Issue with MAX and filter context

[gumis_rulez]

How to properly calculate MAX Net Revenue for Each agent in all years? I am using following measure:

Max Test = 
    MAXX(
        ALLEXCEPT(dim_Calendar, dim_Calendar[Year]),
        [Net Revenue]
    )

But it seams is not working properly. For Adam Metcalfe for each year, value should be 25 963.

https://drive.google.com/file/d/1R3QwcUbAH9ep24L14gjmOeux4ClgU56z/view?usp=sharing 

[DimaMD · Accepted solution]

Hi @gumis_rulez is this your desired outcome?