Creating a new calculated measure for a maximum value in a dimension

Hi,

I have been trying to do this but missing something. Here I want a new column “Overall Result” which gives the result of maximum run id for each test case.
For example for Test case T1, new column should give “Not Tested” as the Result for max Run ID (3) is Not Tested.
For Test case T2 it should give me “Passed” as the result for maximum Run ID (5) related to that test case is Passed. I have imported this data from a csv file, so all the headers that you see are the dimensions.
Please let me know if you have any questions.
Thank you.
image