Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Dynamic RLS DAX Syntax Errors - IF Function

I am trying to create a DAX expression for a Dynamic RLS design but keep receiving a syntax error.   The two tables used in the expression are a Users_tbl and a Permissions_Table.  The Users_tbl ha...
Need Help
  • amitchandak's avatar
    amitchandak
    3 years ago

    Anonymous ,

    try like

    if(Maxx(temp_table,temp_table[Senior Manager_RLS]) ="None",
    TRUE,
    [Email]=USERPRINCIPALNAME()
    )

     

    or

     

    Maxx( FILTER(Permissions_Table, Permissions_Table[Email]=USERPRINCIPALNAME()),[Senior Manager_RLS]) ="None" || [Email]=USERPRINCIPALNAME()

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
3 years ago

Anonymous ,

try like

if(Maxx(temp_table,temp_table[Senior Manager_RLS]) ="None",
TRUE,
[Email]=USERPRINCIPALNAME()
)

 

or

 

Maxx( FILTER(Permissions_Table, Permissions_Table[Email]=USERPRINCIPALNAME()),[Senior Manager_RLS]) ="None" || [Email]=USERPRINCIPALNAME()