the end of input was reached in rls

[shivapriya]

 IF (USERPRINCIPALNAME() = LOOKUPVALUE(VW_ROLE_ACCESS_EMAIL[COMPANY EMAIL ID], VW_ROLE_ACCESS_EMAIL[Datafrom],"XYZ",
VW_ROLE_ACCESS_EMAIL[Role],"Super User",
VW_ROLE_ACCESS_EMAIL[COMPANY EMAIL ID],USERPRINCIPALNAME()),
TRUE (),
OR(
OR(
OR(
OR(
[L1_EMAIL] = USERPRINCIPALNAME (),
[L2_EMAIL] = USERPRINCIPALNAME ()),
[L3_EMAIL] = USERPRINCIPALNAME ()),
[L4_EMAIL] = USERPRINCIPALNAME ()
)))

I am getting the end of input was reached error. i am trying to apply dynamic rls in this statement.Pleasenhelp me asap

[v-jialongy-msft · Accepted solution]

Hi @shivapriya 

Please try the following DAX

IF (
    USERPRINCIPALNAME() = LOOKUPVALUE(
        VW_ROLE_ACCESS_EMAIL[COMPANY EMAIL ID], 
        VW_ROLE_ACCESS_EMAIL[Datafrom], "XYZ", 
        VW_ROLE_ACCESS_EMAIL[Role], "Super User", 
        VW_ROLE_ACCESS_EMAIL[COMPANY EMAIL ID], 
        USERPRINCIPALNAME()
    ),
    TRUE,
    OR(
        [L1_EMAIL] = USERPRINCIPALNAME(),
        [L2_EMAIL] = USERPRINCIPALNAME(),
        [L3_EMAIL] = USERPRINCIPALNAME(),
        [L4_EMAIL] = USERPRINCIPALNAME()
    )
)

Best Regards,

Jayleny

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.