Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

find corresponding value to maxi value in another column

Hi Experts

 

I am trying to find the coresponding value in column b to the max value in column A......totally lost...

= lookupvalue(Client_Summary_[Division],Client_Summary_[ClientName],CALCULATE(MAX(Client_Summary_[ManagementReferralsF2F]),FILTER(Client_Summary_,Client_Summary_[ClientName]=SELECTEDVALUE(Client_Summary_[ClientName])))

Need Help

3 Replies

  • v-danhe-msft's avatar
    v-danhe-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    8 years ago

    Hi Anonymous,

    Could you please post me some sample data and your desired result?

     

    Regards,

    Daniel He

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

       

      See attached image....so for Management F2F i would like to know the division it relates too..

      • v-danhe-msft's avatar
        v-danhe-msft
        Icon for Microsoft Employee rankMicrosoft Employee
        8 years ago

        Hi Anonymous,

        Based on your sample data, what is your desired result? It seemed the three columns has noting related and what kind of value you want to lookup for?

         

        Regards,

        Daniel He