cancel
Showing results for
Did you mean:
Highlighted
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

## 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.
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

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)

Regular Visitor

## 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?

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

## Re: Max Value Error

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

Regards,
Ashish Mathur
http://www.ashishmathur.com

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

## Re: Max Value Error

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

Announcements

#### Coming Soon: T-Shirt Design Contest

Keep your eyes open for our upcoming T-shirt design contest!

#### Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

#### Super User Challenge: Can You Solve These?

We're celebrating the start of the New Super User season with our first ever Super User 'Can You Solve These?' challenge.

#### Power BI Desktop Update - February 2020

We are super excited for our update this month, as we are releasing two of our top community requests!