Forum Discussion

obriaincian's avatar
obriaincian
Resolver I
3 years ago

Nested IF AND Statements

Hi All,

 

I have what seems to be a very simple formula that doesn't seem to be working.

 

All I want to do is return the workstream DRI Email where the workstream DRI Email = USERPRINCIPLENAME(),

If the USERPRINCIPLENAME() is not in the workstream DRI Email check if it's in the Hiring Manager Email if it is return the Hiring Manager Email else "Not a manager or DRI".

 

The issue I'm having is the formula is returning results for both if conditions, I only want it to retun the Hiring Manager Email if the first IF condition isn't met

 

Please see the formula below:

 

 

Var User_ = USERPRINCIPALNAME()

RETURN
IF(
    SELECTEDVALUE(Data[Workstream DRI Email]) = User_,
    SELECTEDVALUE(Data[Workstream DRI Email]),
    IF(
        SELECTEDVALUE(Data[Hiring Manager Email]) = User_ &&
        SELECTEDVALUE(Data[Workstream DRI Email]) <> User_,
        SELECTEDVALUE(Data[Hiring Manager Email]),
        "Not a manager or DRI"
    )
)

 

Need Help

5 Replies

  • obriaincian's avatar
    obriaincian
    Resolver I
    3 years ago

    mlsx4 ,

     

    It looks like the issue lies with the use of SELECTEDVALUE and the fact that I use this measure in a filter for a visualisation.

    The filter for the visualisation is filter out data where the measure does not return "Not a manager or DRI"

  • mlsx4's avatar
    mlsx4
    Memorable Member
    3 years ago

    Hi obriaincian 

     

    Var User_ = USERPRINCIPALNAME()

RETURN
IF(
    SELECTEDVALUE(Data[Workstream DRI Email]) = User_,
    SELECTEDVALUE(Data[Workstream DRI Email]),
    IF(
        SELECTEDVALUE(Data[Hiring Manager Email]) = User_ &&,
        SELECTEDVALUE(Data[Hiring Manager Email]),
        "Not a manager or DRI"
    )
)

     

    I think you don't need the && condition. If you are in the "FALSE" part of the condition is because the first line is not met. That is  Workstream DRI Email is not the same as User_

    • mlsx4's avatar
      mlsx4
      Memorable Member
      3 years ago

      obriaincian 

       

      But have you tried if the condition is ever met? I mean, with a silly example:

      Var User_ = USERPRINCIPALNAME()

RETURN
IF(
    SELECTEDVALUE(Data[Workstream DRI Email]) = User_,
    1,
    0
)

       

      • obriaincian's avatar
        obriaincian
        Resolver I
        3 years ago

        mlsx4 , yes I have. I just can't figure out why it returns data for both IF statements