Max Value Error

[Anonymous]

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. 

[MattAllington · Accepted solution]

=MAXX(ALL(Calendar),[DPD RPI])

[jdbuchanan71]

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)

[Anonymous]

Hi @jdbuchanan71

i create this measure

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

 but still getting incorrect value.

[Ashish_Mathur]

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.

[Anonymous]

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

[Ashish_Mathur]

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

[Anonymous]

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

[MattAllington]

the problem is the ALL function
Try this
Highest Rev/traffic = MAXX(Calender,[MTD RPT])

[Anonymous]

@MattAllington Any Other Way?

[MattAllington · Accepted solution]

=MAXX(ALL(Calendar),[DPD RPI])

[Anonymous · Accepted solution]

@MattAllington  Thank You so much

Its Work 

Highest Rev/traffic = MAXX(Calender,[DBD RPT])

thanks to all @MattAllington @MattAllington @jdbuchanan71 

[Anonymous]

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

[jdbuchanan71]

Hello @Anonymous ,

Can you share the formula in your [MTD RPT] measure?  Given your screen shot, what value are you wanting to see in your measure?

[Anonymous]

@jdbuchanan71  I USE THIS 

MTD RPI = TOTALMTD([DBD RPI],Calender[DateKey])

DBD RPI = [DBD SBI GP]/[DBD INVOICE COUNT]