Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Dynamic RLS Help

Hi All,   Im an RLS noob so to speak and trying to figure things out, so I have built a Security table something like this:   Email: Account: Region Country: [email protected] Apple EURO...
Need Help
v-yuta-msft's avatar
v-yuta-msft
Community Support
6 years ago

Anonymous ,

 

How about using dax below?

[Account] =
CALCULATETABLE (
    VALUES ( SECURITY[Account] ),
    FILTER (
        ALL ( SECURITY ),
        SECURITY[Email] = USERPRINCIPALNAME ()
            && SECURITY[Account] <> BLANK ()
    )
)

Community Support Team _ Jimmy Tao

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

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Thanks so much for your reply,

 

I just tried this as

 

[Account]
IN CALCULATETABLE (
VALUES ( SECURITY[Account] ),
FILTER (
ALL ( SECURITY ),
SECURITY[Email] = USERPRINCIPALNAME()
&& SECURITY[Account] <> BLANK ()
)
)

 

and the table still stays filtered? (doesnt work as an = either sadly 😞

  • vik0810's avatar
    vik0810
    Resolver V
    6 years ago

    Anonymous , as far as I understand, your intention is not to filter at all, if the account is empty. You have to use then logical OR instead of AND.

     

     

     

    [Account] IN
CALCULATETABLE (
    VALUES ( SECURITY[Account] ),
    FILTER (
        ALL ( SECURITY ),
        SECURITY[Email] = USERPRINCIPALNAME ()
            || ISBLANK(SECURITY[Account])
    )
)

     

     

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Thanks vik0810 

       

      That returns nothing at all though, What I want to happen is the filter to basically leave everything UNFILTERED. 

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        Im starting to wonder is what im hoping unrealistic / unachievable using RLS?