Forum Discussion

Rathod's avatar
Rathod
Frequent Visitor
2 years ago
Solved

Return second lookup value instead of first value

Hi All, Could someone please assist me in retrieving the second lookup value instead of the first one? Here are the details: Table Name: Roles_EmailID When the user "[email protected]...
  • rajendraongole1's avatar
    rajendraongole1
    2 years ago

    Hi Rathod -The rank must correctly differentiate between the different email IDs associated with each RolesEmailid.

     

     

    create a measure:

    SecondEmailID =
    CALCULATE(
        FIRSTNONBLANK(abcdef[Email_IDS], 1),
        FILTER(
            abcdef,
            abcdef[RolesEmailid] = USERPRINCIPALNAME() &&
            abcdef[EmailRank] = 2
        )
    )

    Verify that the value returned by USERPRINCIPALNAME() matches exactly with the values in the RolesEmailid column.

     

    Hope this helps

     

  • Rathod's avatar
    Rathod
    2 years ago

    Hi Gautam,

     

    Thanks, its working fine

rajendraongole1's avatar
rajendraongole1
Icon for Super User rankSuper User
2 years ago

Hi Rathod -The rank must correctly differentiate between the different email IDs associated with each RolesEmailid.

 

 

create a measure:

SecondEmailID =
CALCULATE(
    FIRSTNONBLANK(abcdef[Email_IDS], 1),
    FILTER(
        abcdef,
        abcdef[RolesEmailid] = USERPRINCIPALNAME() &&
        abcdef[EmailRank] = 2
    )
)

Verify that the value returned by USERPRINCIPALNAME() matches exactly with the values in the RolesEmailid column.

 

Hope this helps

 

Rathod's avatar
Rathod
Frequent Visitor
2 years ago

Hi Rajendra,

Thanks for your swift response, i tried with your dax but unfortunatly getting below error