Find max value based on another column

[Anonymous]

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])))

[Zubair_Muhammad · Accepted solution]

@Anonymous

In a MEASURE, typically you can not use EARLIER

Consider replacing EARLIER with SELECTEDVALUE

[Anonymous]

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]

@Anonymous

Try with

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

[Anonymous]

Zubiar

I managed to solve the measure. Thanks

[Anonymous]

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.