Forum Discussion

samnaw's avatar
samnaw
Resolver I
6 years ago

Max value help

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? 

 

 

Need Help

1 Reply

  • amitchandak's avatar
    amitchandak
    Super User
    6 years ago

    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.