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.
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?
jdbuchanan71 I USE THIS
MTD RPI = TOTALMTD([DBD RPI],Calender[DateKey])DBD RPI = [DBD SBI GP]/[DBD INVOICE COUNT]