compare one employee to the team, in spite of RLS on employee

[Louke]

Hello all,

I would like to compare the revenue of one employee to the team revenue, although I use RLS.

I got a dimension of my employees:

Employee	Team
Jack	Germany
Megan	Germany
Cathie	Germany
Caroline	Austria
Susi	Austria
Michael	Austria
Luise	Suisse
Tim	Suisse

I got a fact table of my orders:

OrderID	Employee	Revenue
200056	Jack	50,00 €
200057	Michael	150,00 €
200058	Megan	100,00 €
200059	Megan	50,00 €
200060	Cathie	200,00 €
200061	Luise	150,00 €
200062	Caroline	200,00 €
200063	Tim	50,00 €
200064	Michael	150,00 €
200065	Megan	100,00 €
200066	Susi	100,00 €

Now, I would like to get the revenue of one employee and for comparison the revenue of the whole team:

Month	Employee	Revenue	Team
January	Jack	50,00 €	500,00 €
January	Megan	250,00 €	500,00 €
January	Michael	300,00 €	600,00 €

With the a slicer and the "ALL"-expression I could show the revenue of the team:

When I publish it to the service with RLS for every employee, it will not show the Team-Revenue in the version of the employees.

A solution would be to copy the "Table" and use the Team-Coulumn as Key-Coulumn for the relationship.

Does anyone know a smart way how to solve this or is my solution the only way?

Thank you so much in advance!

[v-mengzhu-msft · Accepted solution]

Hi @Louke ,

You can use your own good method, it should also be effective.In addition to that, I noticed that you use RLS and perhaps you can also configure RLS to manage what your employees can see. Using your data as an example, you would be able to set up each member to be able to see their own and the team's revenue. The configuration can be found in this document.

Row-level security (RLS) guidance in Power BI Desktop - Power BI | Microsoft Docs

But in fact, what I have in mind seems far less simple than yours, and I would advise you more to use your own familiar way to reach your goal.

Best regards,

Community Support Team Selina zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly