cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
M_OVAISJANZEB Regular Visitor
Regular Visitor

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

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 Regular Visitor
Regular Visitor

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

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 Regular Visitor
Regular Visitor

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

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 Regular Visitor
Regular Visitor

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

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.

M_OVAISJANZEB Regular Visitor
Regular Visitor

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

Re: Max Value Error

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

Highlighted
Super User
Super User

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 Regular Visitor
Regular Visitor

Re: Max Value Error

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

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Users Online
Currently online: 54 members 1,154 guests
Please welcome our newest community members: