topic Re: Returning value based on multiple criteria in DAX Commands and Tips

Returning value based on multiple criteria

Anonymous — Wed, 31 May 2023 07:38:00 GMT

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

[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 — Wed, 31 May 2023 09:15:10 GMT

Hi Anonymous
Please try

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

Anonymous — Wed, 31 May 2023 11:18:38 GMT

Thank you so much for your help, much appreciated.