Multiple Slicer with Row Level Security(userprinicipalName())

[Anonymous]

Hi Team,

Good day,

I have Two tables

Country table below

Country	State	population
INDIA	Maharastra	10000
INDIA	AP	20000
UK	ABC	40000
US	CD	50000

Employee table

EmpName	Dep
Shanvitha	IT
ABC	HR
Johne	IT

Based on above I have created 3 Slicer in Power BI

1.Country

2.State

3.EmpName

I have created Below is RLS table because I am using Row Level Security (UserprinicipalName())

EMP_ID	Email	Country	State	EmpName
1010	Shanvitha.L@abccompany.com	INDIA	AP	Shanvitha
1020	Johne.J@abccompany.com	US	CD	Johne

I have given relation Country table and RLS table Country column <-->Country column

once I will create the Row Level Security in Power BIdesktop(Email=Userprinicipalname()) then view as cheched with Shanvitha.L@abccompany.com its fillter only Country slicer but didnt filter the values(State,EmpName)

Please help I need filter Country,State,EmpName slicer in the report using Row Level Security in Power BI

Thanks

Shanvitha

[v-kkf-msft · Accepted solution]

Hi @Anonymous ,

Create relationships for columns Country\State\EmpName.

Then create role:

[State] = CALCULATE(values('RLS Table'[State]),USERELATIONSHIP('Country table'[State],'RLS Table'[State]))

[Email] = USERPRINCIPALNAME()

View as cheched with Shanvitha.L@abccompany.com.

If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.

Best Regards,
Winniz

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

[PavanVanguri]

Hi @v-kkf-msft,

Thanks for the solution, I have same data structure, but more columns to use for RLS, like I have Region, Sub Region, Country, RVP, Site and LOB.
I'm exploring how to implement RLS using above 6 columns, all these columns are coming from one fact table, and I have a RLS Table. Could you please suggest me how to implement RLS using 6 columns.

Thanks
Pavan.