Take the max value based on a condition from another column

[Anonymous]

Days Since Install Score = DIVIDE('Failure Table'[Days Since Installation], MAX('Failure Table'[Days Since Installation]))

I want to use the equation shown above as a column in my table 'Failure Table', but modify it to only take the max of the [Days Since Installation] where 'Failure Table'[Install Day].[Year]<>1950. I tried doing:

Days Since Install Score = DIVIDE('Failure Table'[Days Since Installation], Calculate(MAX('Failure Table'[Days Since Installation]),'Failure Table'[Install Day].[Year]<>1950))

However, this resulted in all cells = 1, just dividing the cell by itself rather than the max value of the column where year doesn't equal 1950.

How can I solve this problem? Thanks in advance.

[johnt75 · Accepted solution]

Days Since Install Score =
DIVIDE (
    'Failure Table'[Days Since Installation],
    CALCULATE (
        MAX ( 'Failure Table'[Days Since Installation] ),
        REMOVEFILTERS ( 'Failure Table' ),
        'Failure Table'[Install Day].[Year] <> 1950
    )
)