Max value help

[samnaw]

Hello:

I have a question regarding max value. I apologize if my question is not formulated that well. 

1) I have created a calculated measure called "CY_OR"

2) When the end-user clicks on "FY" either 2020 or 2019 I want the max value for that FY year

3) When the end-user clicks on "mth_name" the the max value futher filters by month. 

4) Then I want the "campaignname" associated with with it. 

I am not sure the best way to go about doing this? 

[amitchandak]

@samnaw , That is the default behavior unless changed by the formula .

maxx(Table,[CY_OR])

The information you have provided is not making the problem clear to me. Can you please explain with an example.

Appreciate your Kudos.