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
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)