cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
M_OVAISJANZEB
Helper IV
Helper IV

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

=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

@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
jdbuchanan71
Super User
Super User

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)

Hi @jdbuchanan71

i create this measure

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

 but still getting incorrect value.

 

Capture2.PNGCapture.PNG

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/

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

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


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

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

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.

@MattAllington Any Other Way?

=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

@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

@MattAllington I remove all but it doesn't work.

 

Capture3.PNG

 

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?

@jdbuchanan71  I USE THIS 

MTD RPI = TOTALMTD([DBD RPI],Calender[DateKey])
 
DBD RPI = [DBD SBI GP]/[DBD INVOICE COUNT]

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

November Power BI Update 768x460.png

Check it Out!

Click here to read more about the November 2021 Updates!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.