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

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

Rathod , You can try using RANKX for this 

 

VAR _getRoles =
CALCULATE (
FIRSTNONBLANK ( Roles_EmailID[Email_IDS], 1 ),
FILTER (
ADDCOLUMNS (
FILTER ( ALL ( Roles_EmailID ), Roles_EmailID[RolesEmailid] = USERPRINCIPALNAME() ),
"Rank", RANKX ( FILTER ( ALL ( Roles_EmailID ), Roles_EmailID[RolesEmailid] = USERPRINCIPALNAME() ), Roles_EmailID[Email_IDS], , ASC, DENSE )
),
[Rank] = 2
)
)

RETURN
_getRoles

Rathod's avatar
Rathod
Frequent Visitor
2 years ago

Hi Gautam,

 

Thanks, its working fine