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

Hi Anonymous 

Could you tell me if your problem has been solved? If it is, kindly share your way or the reference material with us. More people will benefit from it. Or you are still confused about it, please provide me with more details about your table or share me with your pbix file from your onedrive for business.

Best Regards,

Rico Zhou

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.