RLS by Brand

[Sriram_K]

Hi All

I have brand and Country columes in Row level sequrity table

my requriment is now abc4@gmail.com in brand colume have value as All,now abc4@gmail.com should get access for All brands (Ex:abc4@gmail.comshould get access for 3 brands Bajaj,Vespa&Honda)

DAX used to impleament RLS in my dataset
NOT(ISBLANK(LOOKUPVALUE(RLS[Brand],RLS[Brand],[Brand],RLS[Email ],userprincipalname())))
can any one help me on this

Thanks
Sriram.K

[v-rzhou-msft]

Hi @Sriram_K 

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

[Sriram_K · Accepted solution]

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]

@Sriram_K
Glad it's working! Please mark the answer as a solution so others can find it easily too and benefit.

[v-rzhou-msft]

Hi @Sriram_K 

If you don't set RLS, the user can see all table Brand values. Please provide me with more details about your table or share your pbix file with me.

And show me your problem and the result you want.

I hope the blogs about RLS can help you, links are as below:

https://docs.microsoft.com/en-us/power-bi/guidance/rls-guidance

https://docs.microsoft.com/en-us/power-bi/admin/service-admin-rls

https://community.powerbi.com/t5/Service/RLS-for-default-Value-Show-all/td-p/231465

Best Regards,

Rico Zhou

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

[AllisonKennedy]

Sorry, I don't understand your question. Can you provide a bit more detail and what you're tables look like? What's not working? What is your desired result?