Dynamic ROW level security

[George963852395]

Hi All,

I have 8 tables that all have relationships (single) to a table like this

EmployeeName (FirstName LastName)	DefaultSales_SalesLineName1	DefaultSales_PhysicalOfficeName1	Email	Job Title	Rank
John Smith	APAU	Midla	john.smith@xyz.co.uk	Area Sales Manager	5
Jenny johnson	SENS	South	jenny.johnson@xyz.co.uk	Team leader	4

If someone views the dashboard I need to cross reference there email to this where they can only see data from there office, there division and only job titles that are below there number, example, Area sales manager (5) would see Team leader data (4) and thats it.

My current DAX formula for role is:

'Sales Name'[Email]= USERPRINCIPALNAME() &&

'Sales Name'[Job Title] IN VALUES('Sales Name'[Rank]) &&

'Sales Name'[Office] = SELECTEDVALUE('Sales Name'[Office]) &&

'Sales Name'[Division] = SELECTEDVALUE('Sales Name'[Division])

Currently no data will display for anyone. I feel like im doing this all very wrong but I am very new to this. Any help much appreciated.

[SaiTejaTalasila]

Hi,

You can refer this one.

https://radacad.com/dynamic-row-level-security-with-organizational-hierarchy-power-bi

[George963852395]

For reference here are my relationships