Forum Discussion
Anonymous
7 years agoNot applicable
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.
- 7 years ago
=MAXX(ALL(Calendar),[DPD RPI])
- Anonymous7 years ago
MattAllington Thank You so much
Its Work
Highest Rev/traffic = MAXX(Calender,[DBD RPT])thanks to all MattAllington MattAllington jdbuchanan71
Anonymous
7 years agoNot applicable
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
7 years agoSuper User
Share the link from where i can download your PBI file.
- MattAllington7 years agoCommunity Championthe problem is the ALL function
Try this
Highest Rev/traffic = MAXX(Calender,[MTD RPT])- Anonymous7 years agoNot applicable
- Anonymous7 years agoNot applicable
MattAllington Any Other Way?
- MattAllington7 years agoCommunity Champion
=MAXX(ALL(Calendar),[DPD RPI])
- Anonymous7 years agoNot applicable
Ashish_Mathur THERE IS SOME CONFIDENTIAL DATA WHICH I CANT SHARE. there is any other way ???