Using Slices to create User Security

[VLMark37]

I am currently using the following security formula on a table so that the user only sees jobs (from "JOBS" table) they are reassigned to:

IFS(

    ANY(Current_User[Role]) = "Admin",

    TRUE,

    ANY(Current_User[Role]) = "Manager",

    [Reassign Driver].[Branch] = ANY(Current_User[Branch]),

    ANY(Current_User[Role]) = "Project Manager",

    OR(

        [Reassign Driver] = USEREMAIL(),

        AND(

            [Reassign Driver].[Branch] = ANY(Current_User[Branch]),

            [Reassign Driver].[Role] = "Driver",

            [Job Type] = "Project"

        )

    ),

    TRUE,

    OR(

        [Reassign Driver] = USEREMAIL(),[Assigned Driver]= USEREMAIL(),

        IN(USEREMAIL(), [Assigned Team])

    )

)

I would like to remove the security formula from the "JOBS" table and create a slice for each user role.

I temporarily removed the security formula from the "JOBS" table and tried to apply a slice filter.  

When I used the formula, "[Reassigned Driver]=USEREMAIL()", all results display "N" even though I was signed in as the driver and there were jobs reassigned to that driver.  

Example:  Signed in as "(PII Removed by Staff)" and "(PII Removed by Staff)" was displayed in the "reassigned driver" Jobs column.  Logically, the result should be "Y"; however, all jobs are returning a "N" result.  

Please help.

Thanks,

VLMarks

[AleksiAlkio]

It sounds that you didn't save the security filter change before testing the slice formula. That would explain this behavior.

[VLMark37]

I did save after deleting the security filter.  That's the frustrating thing.