Subset of data filtered on dashboard

[DNGP]

Hi There!

I'm not even sure whether what I want to do is possible, but I'll give it a try.

I have a table that lists details of employees i.e. their ID, their name, name of their supervisors, supervisors ID, and other information. The supervisors are also employees, so their name is listed as employees in this table as well.

Users of this dashboard have to form a group out of this database. They can do that by applying multiple filters on this dashboard in order to scope down the population that they want to form a group. Once a group is formed, it's possible that some supervisors are captured in the same group as their team members.

What I'm trying to see is that - how many employees are in this same group as their team members. Is this possible? If yes, how can I achieve that?

Your help is appreciated. Thank you!

[v-frfei-msft]

Hi @DNGP ,

Did you mean RLS in power bi? Please refer to the online document as below.

https://docs.microsoft.com/en-us/power-bi/service-admin-rls 

[DNGP]

Hi @v-frfei-msft ,

I think that's not what I'm trying to achieve. Let me clarify the issue.

I connected my Power BI to a table that looks similar to the one below. And I created a chart in Power BI.

Let's say a user of this dashboard can apply the country filter - "USA". The chart will show that in USA group, there are 4 employees and 3 distinct supervisors (Employee C and D have the same supervisor).

What I need to see on this dashboard is that how many suervisors are captured in this USA group together with their team members. For this specific case, it should show 1 supervisor (Supervisor AA). How can I do that?

Appreciate all the help and guidance!

Employee ID      Employee Name     Supervisor ID     Supervisor Name     Employee Country

1                               A                                       21                              AA                                     USA

2                               B                                       22                              BB                                      Canada

3                               C                                       23                              CC                                      USA

4                               D                                       23                              CC                                      USA

21                           AA                                     31                              XX                                      USA

31                           ZZ                                     41                              YY                                      Canada