I am having a table called Employee
I have key value as [Email]
[Role] column
I want to set a security filter that Admin role people can see all records and user can see only their records
I used below expression but it throws error
Expression which is used :
IF(IN(USEREMAIL(),SELECT(Employee[Email ID],[Role]=Admin)),TRUE, [Email ID] = USEREMAIL())
Please suggest correct expression !
User | Count |
---|---|
35 | |
11 | |
3 | |
3 | |
2 |