Forum Discussion

VitaliiCH17's avatar
VitaliiCH17
Frequent Visitor
3 years ago

Dynamic Row Lever Security doesn't work with multiple columns

Hi, I'm trying to implement RLS based on the multiple columns. All this columns are in the same table. My expression is following:   "True" = CALCULATE ( MAX(AUTHORIZATION[global]), AUTHORIZATI...
Need Help
lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
3 years ago

 

 

"True" =
CALCULATE (
    MAX ( AUTHORIZATION[global] ),
    AUTHORIZATION[email] = USERPRINCIPALNAME ()
)
    || CONTAINSSTRING (
        CALCULATE (
            ( MAX ( AUTHORIZATION[Area] ) ),
            AUTHORIZATION[email] = USERPRINCIPALNAME ()
        ),
        "|" & COALESCE([Area],"UNKNOWN") & "|"
    )
    || CONTAINSSTRING (
        CALCULATE (
            ( MAX ( AUTHORIZATION[subRegionCodeNew] ) ),
            AUTHORIZATION[email] = USERPRINCIPALNAME ()
        ),
         COALESCE([Sub Region],"UNKNOWN") 
    )
    || CONTAINSSTRING (
        CALCULATE (
            ( MAX ( AUTHORIZATION[Region] ) ),
            AUTHORIZATION[email] = USERPRINCIPALNAME ()
        ),
         COALESCE([REGION],"UNKNOWN") 
    )

 

 

You have chained "OR"  statements.  Did you mean to use SWITCH() instead?

Also seems to be missing the sticks for the last few options, and has some field name inconsistencies.