Compare own Username to anonymous data

[ssgtom]

Hi,

we made a survey in our company in order to asses some employees.

Each assessed employee should be able to see their result in a Power BI report. BUT each employee should only see the own result with the real name, all others shall be shown as "Anonymous xxxxx".

The data model can be found here: Data Model

I can't use the function USERPRINCIPALNAME() in a calculated column. Using a measure doesn't work for me, since I want to use a couple of matrix-visuals. 

I tried to create a new table with all possible Usernames and giving this table no relation to other tables at all, so I can apply RLS on this table and use a LOOKUPVALUE() on this table. Didn't work for me neither.

I searched forum for a while but couldn't find a solution that works for me.

Can anybody help?

[ibarrau]

Hi. RLS is not apply for a measure. It is for datasources. You can add a rule like UserPrincipalName = USERNAME() for the users table. The option is in Modeling Tab.

I think this is what you are looking for.

Regards

[ssgtom]

Hi,

thanks for the reply, but this is acutally not what I am looking for. RLS (applied on datasource of course) filters all rows that do not match the username. But I do not want to filter them, I just want to replace the name by anonymous for all datasets != Username.