cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
pi355113
Frequent Visitor

Returning value based on multiple criteria

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

pi355113_0-1685518640831.png

 

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

1 ACCEPTED SOLUTION
tamerj1
Super User
Super User

Hi @pi355113 
Please try

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

View solution in original post

2 REPLIES 2
tamerj1
Super User
Super User

Hi @pi355113 
Please try

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

Thank you so much for your help, much appreciated.

Helpful resources

Announcements
PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Top Solution Authors
Top Kudoed Authors