Forum Discussion
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.
=MAXX(ALL(Calendar),[DPD RPI])
MattAllington Thank You so much
Its Work
Highest Rev/traffic = MAXX(Calender,[DBD RPT])thanks to all MattAllington MattAllington jdbuchanan71
Hi jdbuchanan71
i create this measure
Highest Rev/traffic = MAX([MTD RPT],0)
but still getting incorrect value.
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.
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.58Share the link from where i can download your PBI file.
- the problem is the ALL function
Try this
Highest Rev/traffic = MAXX(Calender,[MTD RPT])