Max Value within table when condition is met

[kasiaw29]

I need help with something I'm trying to acheieve. Seems simple but giving me a lot of grief. 

I simply need help with dax, I need to find max baseline revision no where cus search = 1.

So in below screenshot I'd only like to see highlighted line. 

I have MAX LC 

IF(

CALCULATE(MAX('Activity History'[Baseline Revision No]),

ALLEXCEPT('Activity History',

'Activity History'[Project]))=MAX('Activity History'[Baseline Revision No]),1,0)

Can anyone help? 

[Tahreem24]

@kasiaw29 ,

Try this below DAX:

Max Rev No  = CALCULATE(MAX('Table'[Rev No.]),FILTER('Table','Table'[Cus Search]=1))

[FrankAT · Accepted solution]

Hello @kasiaw29

what about the following solution:

Max of LC Max = 
CALCULATE(
    MAX('Activity History'[Baseline Revision  No]),
    FILTER(
        ALLEXCEPT(
            'Activity History',
            'Activity History'[Project]
        ),
        'Activity History'[CUS Search] = 1
    )
)

With kind greetings from the city where the legend of the 'Pied Piper de Hamelin' is at home
FrankAT (Proud to be a Datanaut)

[kasiaw29]

Fantasric work! Exactly what I needed. Thank you very very much!

[amitchandak]

@kasiaw29 , Try to have a measure like

Measure =
VAR __id = MAX ('Activity History'[Project] )
VAR __dt = CALCULATE ( MAX('Activity History'[Baseline Revision No] ), ALLSELECTED ('Activity History' ), 'Activity History'[Project] = __id ,'Activity History'[cus search]=1)
CALCULATE ( Min ('Activity History'[Baseline Revision No] ), VALUES ('Activity History'[Project ),'Activity History'[Project] = __id,'Activity History'[Baseline Revision No] = __dt ,'Activity History'[cus search]=1)

[kasiaw29]

@amitchandak  Unfortunately I'm getting this error 

[amitchandak]

@kasiaw29 , my bad , return is missing

Measure =
VAR __id = MAX ('Activity History'[Project] )
VAR __dt = CALCULATE ( MAX('Activity History'[Baseline Revision No] ), ALLSELECTED ('Activity History' ), 'Activity History'[Project] = __id ,'Activity History'[cus search]=1)
return
CALCULATE ( Min ('Activity History'[Baseline Revision No] ), VALUES ('Activity History'[Project ),'Activity History'[Project] = __id,'Activity History'[Baseline Revision No] = __dt ,'Activity History'[cus search]=1)