Using USERNAME() as a filter AFTER RLS is applied

[stuartta]

Hello,

I am trying to set up a dashboard with multiple views based on a filter that is derived from the USERNAME function.

At the moment the data has RLS applied to it so that when someone logs on, it will only show them those people underneath them in the organisation by applying a combination of PATH and PATHCONTAINS, this works well, but I want to add a new column to the table based on the USERNAME() output to allow users to select whether they see everyone below them or just their imediate team.

I was trying to set up an additional conditional column that was along the lines of:

Filter = IF([Mananger]=Username(),"Team","Organisation")

So if the person logged on is the employees direct manager the column contains "team", if they are in their management hierarchy they see "Organisation"

That throws up the error message "CUSTOMDATA, USERNAME, USERCULTURE and USERPRINCIPALNAME functions are not supported in calculated tables/columns. These functions may only be used in Measures or in the AllowedRowsExpression."

Any idea how I can implement this?

Cheers

[Stachu · Accepted solution]

the problem is not really related to RLS. The issue is that the calculated columns/tables are only changing during the refresh. The way you describe it the column would have to change between Team/Organization depending on who is logged in - at the moment PowerBI just doesn't work like this

to make it work you would need to have both the Organization and Team versions of the table for relevant users, and then filter with RLS