RLS using common user id

[RashmitaR]

Hi , I am trying to create a report

User_id	Email id	Project Id	value
1	Pras@abc.com	P_001	1000
2	Pras@abc.com	P_002	20000
3	Gop@abc.com	P_003	20000
4	Gop@abc.com	P_004	15000

Here user 1 and 2 are logging into power bi using Pras@abc.com user id and user 3 and 4 are loggoin into power bi using Gop@abc.com user id .
but all the users are allocated to different project .
If i want to create a role where each user can only be able to have a look at its respective project value , Could someone please help me with the DAX that I should mention in the filters.

Or is there any other way to achieve this functionality?

[v-yuezhe-msft]

Hi @RashmitaR，

In your scenario, it is not possible to create a role to make each user to view his respective project value. When you make use of USERNAME() function within your dataset, Power BI will automatically filter the data depending on the username used to login to Power BI service account.

In other words, as the users log into Power BI Service using email id, they always get two project values. You would need to ensure that they use different email id to log into Power BI.

Thanks,
Lydia Zhang