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.
