Forum Discussion

gumis_rulez's avatar
gumis_rulez
Icon for Helper I rankHelper I
1 year ago
Solved

Issue with MAX and filter context

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 

1 Reply