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]
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
Highlighted
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.

Top Solution Authors
Top Kudoed Authors