Returning value based on multiple criteria

[Anonymous]

Please could you kindly help, I am trying to get a column to return a number based on: 

IF

[High Potential?] = No and blank 

[Severity#] = 37

Return 7

AND

[High Potential?] = Yes

[Severity#] = 37

Return 3

AND

[Severity#] = any other numbers

Return [Severity#] value

Thank you very much

[tamerj1 · Accepted solution]

Hi @Anonymous 
Please try

Value =
IF (
    'Table'[Severity#] = 37,
    IF ( 'Table'[High Potential?] = "Yes", 3, 7 ),
    'Table'[Severity#]
)

[Anonymous]

Thank you so much for your help, much appreciated.