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
13 Replies
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)
Hi jdbuchanan71
i create this measure
Highest Rev/traffic = MAX([MTD RPT],0)but still getting incorrect value.
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?
