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(Clien...
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

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.