Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

RLS by Brand

Hi All I have brand and Country columes in Row level sequrity table my requriment is now [email protected] in brand colume have value as All,now [email protected] should get access for All bran...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    Hello
    has the solution for this.

    I've created a new columume like New_Column "All." used that column in the Row Level filter.


    DAX used as row-level filter
    NOT(ISBLANK(LOOKUPVALUE(RLS[Country],RLS[Country],[New_Column],RLS[Email ],userprincipalname())))
    ||
    NOT(ISBLANK(LOOKUPVALUE(RLS[Brand],RLS[Brand],[brand],RLS[Email ],userprincipalname())))


Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hello
has the solution for this.

I've created a new columume like New_Column "All." used that column in the Row Level filter.


DAX used as row-level filter
NOT(ISBLANK(LOOKUPVALUE(RLS[Country],RLS[Country],[New_Column],RLS[Email ],userprincipalname())))
||
NOT(ISBLANK(LOOKUPVALUE(RLS[Brand],RLS[Brand],[brand],RLS[Email ],userprincipalname())))


AllisonKennedy's avatar
AllisonKennedy
Community Champion
6 years ago
Anonymous
Glad it's working! Please mark the answer as a solution so others can find it easily too and benefit.