cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
M_OVAISJANZEB Helper II
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.

View solution in original post

M_OVAISJANZEB Helper II
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 

View solution in original post

13 REPLIES 13
Super User IV
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)

M_OVAISJANZEB Helper II
Helper II

Re: Max Value Error

Hi @jdbuchanan71

i create this measure

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

 but still getting incorrect value.

 

Capture2.PNGCapture.PNG

Super User IV
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?

M_OVAISJANZEB Helper II
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]
Highlighted
Super User IV
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/
M_OVAISJANZEB Helper II
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
 
Capture2.PNG
Super User IV
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.
M_OVAISJANZEB Helper II
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!

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!

‘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

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 Microsoft Power Platform event series.

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

Community Summit North America

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

Top Solution Authors