Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
gumis_rulez
Helper I
Helper I

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.

max_issue.JPG

 

 

 

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

1 ACCEPTED SOLUTION
DimaMD
Solution Sage
Solution Sage

Hi @gumis_rulez is this your desired outcome?

DimaMD_0-1727868288475.png

 


__________________________________________

Thank you for your like and decision

__________________________________________

Greetings from Ukraine

To help me grow PayPal: embirddima@gmail.com

View solution in original post

1 REPLY 1
DimaMD
Solution Sage
Solution Sage

Hi @gumis_rulez is this your desired outcome?

DimaMD_0-1727868288475.png

 


__________________________________________

Thank you for your like and decision

__________________________________________

Greetings from Ukraine

To help me grow PayPal: embirddima@gmail.com

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.