Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Find max value based on another column

Hi Experts

 

i am trying to find the maximum value based on a second column , cannot see the error in my formula...

 

Measure = CALCULATE(MAX(Client_Summary_[ManagementReferralsF2F]),FILTER(Client_Summary_,Client_Summary_[Division]=EARLIER(Client_Summary_[Division])))

 

Need Help
  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    8 years ago

    Anonymous

     

    In a MEASURE, typically you can not use EARLIER

     

    Consider replacing EARLIER with SELECTEDVALUE

5 Replies

  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    Community Champion
    8 years ago

    Anonymous

     

    In a MEASURE, typically you can not use EARLIER

     

    Consider replacing EARLIER with SELECTEDVALUE

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      Hi Zubair

       

      Slight change: i want to find the max value filtered on ClientName first then based on division next... I have a syn'd the fliter show the data show be for client ABC only......the desireed result should be 83.

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      Hi Zubair

       

      Slight change: i want to find the max value filtered on ClientName first then based on division next... I have a syn'd the fliter show the data show be for client ABC only......the desireed result should be 83.

      • Zubair_Muhammad's avatar
        Zubair_Muhammad
        Community Champion
        8 years ago

        Anonymous

         

        Try with

         

        =
CALCULATE (
    MAX ( Client_Summary_[ManagementReferralsF2F] ),
    ALLEXCEPT (
        Client_Summary_,
        Client_Summary_[Division],
        Client_Summary_[ClientName]
    )
)