cancel
Showing results for
Search instead for
Did you mean:
Helper II

Max Value Error

i want to get Max Value of Measure. I use Maxx Function but the Value which its return it Average Value.

Please Guide How can i get Proper Max Value Using Measure.

2 ACCEPTED SOLUTIONS

Accepted Solutions

Re: Max Value Error

=MAXX(ALL(Calendar),[DPD RPI])

* Matt is a Microsoft MVP (Power BI) and author of the Power BI Book Supercharge Power BI.
Helper II

Re: Max Value Error

@MattAllington  Thank You so much

Its Work

Highest Rev/traffic = MAXX(Calender,[DBD RPT])

thanks to all @MattAllington @MattAllington @jdbuchanan71

13 REPLIES 13
Super User IV

Re: Max Value Error

Instead of using MAXX try MAX([your measure],0).  This will pick the higher of the two scalar values [your measure] and 0.  If your measure can go negative but you still want to pull that if it does you would do MAX([your measure],-9999999)

Helper II

Re: Max Value Error

i create this measure

Highest Rev/traffic = MAX([MTD RPT],0)

but still getting incorrect value.

Super User IV

Re: Max Value Error

Hello @M_OVAISJANZEB ,

Can you share the formula in your [MTD RPT] measure?  Given your screen shot, what value are you wanting to see in your measure?

Highlighted
Helper II

Re: Max Value Error

@jdbuchanan71  I USE THIS

MTD RPI = TOTALMTD([DBD RPI],Calender[DateKey])

DBD RPI = [DBD SBI GP]/[DBD INVOICE COUNT]
Super User IV

Re: Max Value Error

Hi,

Try this

=MAXX(ALL(Calendar),[MTD RPT])

I am assuming that the Dates appearing in your Calendar visual have been dragged from the Calendar Table.

Hope this helps.

Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/
Helper II

Re: Max Value Error

HEY @Ashish_Mathur  THANKS FOR REPLY

I USE

Highest Rev/traffic = MAXX(ALL(Calender[DateKey]),[MTD RPT])

RESULT IS 12.47 WHICH IS WRONG. CURRENT VALUE OF WHOLE MONTH IS 22.58

Super User IV

Re: Max Value Error

Share the link from where i can download your PBI file.

Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

Re: Max Value Error

the problem is the ALL function
Try this
Highest Rev/traffic = MAXX(Calender,[MTD RPT])

* Matt is a Microsoft MVP (Power BI) and author of the Power BI Book Supercharge Power BI.
Helper II

Re: Max Value Error

@Ashish_Mathur THERE IS SOME CONFIDENTIAL DATA WHICH I CANT SHARE. there is any other way ???

Helpful resources

Announcements

New Ranks Launched March 24th!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power BI Community!

‘Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

Arun 'Triple A' Event Video, Q&A, and Slides

Missed the Arun 'Triple A' event or want to revisit it? We've got you covered! Check out the video, Q&A, and slides now.

Join THE global Power Platform event series.

Attend for two days of expert-led learning and innovation on topics like AI and Analytics, powered by Dynamic Communities.

Community Summit North America

Innovate, Collaborate, Grow. The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors
Top Kudoed Authors