Row Level Security adding extra filter condition

[rsanyoto]

Hi Guys,

I have the follow Table filter DAX expression to meet some RLS requirement.

I would like to one more filter that return me any employee from Authorizationmanagers table that has "FA" as value from column Responsibility.  In the following DAX code the PBIX doesnt accept this way of formula.

Any suggestions how i can add the responsiblity = "FA"?

Many thanks

VAR authorisationPersonel=
SUMX (
FILTER ( 'Authorization managers', 'Authorization managers'[e-mailadres] = USERPRINCIPALNAME () ),
'Authorization managers'[responsibility] = "FA"),
IF (
PATHCONTAINS ( 'Authorization Occupation'[Org pad], 'Authorization managers'[Organization] ),
1,
0
)
)
RETURN
IF ( authorisationPersonel> 0, TRUE (), FALSE () )

[Anonymous · Accepted solution]

@rsanyoto 

Are you sure the your original measure can run properly? Try this:

Measure =

VAR authorisationPersonel =

SUMX (

FILTER (

'Authorization managers',

'Authorization managers'[e-mailadres] = USERPRINCIPALNAME ()

&& 'Authorization managers'[responsibility] = "FA"

),

IF (

PATHCONTAINS (

'Authorization Occupation'[Org pad],'Authorization managers'[Organization])=TRUE(),

1,

0

)

)

RETURN

IF ( authorisationPersonel > 0, TRUE (), FALSE () )

Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.

[jdbuchanan71]

@rsanyoto Give this a try

VAR authorisationPersonel =
    SUMX (
        FILTER (
            'Authorization managers',
            'Authorization managers'[e-mailadres] = USERPRINCIPALNAME ()
                && 'Authorization managers'[responsibility] = "FA"
        ),
        IF (
            PATHCONTAINS (
                'Authorization Occupation'[Org pad],
                'Authorization managers'[Organization]
            ),
            1,
            0
        )
    )
RETURN
    IF ( authorisationPersonel > 0, TRUE (), FALSE () )

[rsanyoto]

Hi @jdbuchanan71 ,

Thanks for your response but unfortunatly i received a syntax error... which : The syntax for ',' is incorrect.