Forum Discussion
gumis_rulez
Helper I
1 year agoIssue 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
- DimaMD
Solution Sage