thnak you for the reply! it certainly does help my issue although the MAX function seems to calculate weird values instead of the assigned values.
would this be by any Chance because i have Groups on my Dimension?
Can you please share your sample data.
Max function in the calculation shared by me,is calculating the max on the entire table.