Users

[Fre3]

I am trying to assign different users to different groups. 

So when  "Management" is selected in the [Assignee] that specific task is seen in the filtered view of all of the users in "Management" and so on. 

The view is already set up so that the current user can see "1" which is YMP and their own tasks. So if the assignee was changed to management, the current user , if not management or in a different group, would be able to see the corresponding tasks etc. 

My initial thoughts would be I would have to make a table for each of the groups and have each user of the groups in there

[Suvrutt_Gurjar]

Please post this in "Q&A" section.

[Steve]

---

@Fre3 wrote:

So when  "Management" is selected in the [Assignee] that specific task is seen in the filtered view of all of the users in "Management" and so on. 

This makes absolutely no sense to me.

The view is already set up so that the current user can see "1" which is YMP and their own tasks.

---

Also nonsense. What is "1"? What is "YMP"?

So if the assignee was changed to management, the current user , if not management or in a different group, would be able to see the corresponding tasks etc. 

---

Nope, still don't understand.

[dbaum]

I think you don't need "a table for each of the groups". Rather, you probably need one table that has a row for each group and a separate table that has a row for each user. The User table and the Tasks table each need a column that holds the name of the pertinent group, which references the Groups table. Then, to display to a user all the tasks for that user's group, you can use security filters or slices to enter a row-filtering expression that limits the Tasks table's rows to only the tasks assigned to the group of which the current user is a member.

The expression would be along the lines of the following example:

SELECT(Tasks[Task ID], IN([Group ID], SELECT(Users[Group ID], [Email] = USERMAIL())))