Row Filter on Role

[BeginnerBob]

Hi,

I have a column labelled UserID in my Site dimension which has many user accounts i.e. bob@ms.com, Dave@ms.com etc.

I want to have a DAX expression which searches the string and filters the row based on the current user.

I have created a Role called SiteUsers and have added the applicable users into this role. Then in my row filter I've added: SEARCH(USERNAME, [UserID], 1, 0 ) > 0

For example:

Site        UserID

North    bob@ms.com, Dave@ms.com 

South    randy@ms.com

East       clive@ms.com, bob@ms.com

So if my user is bob@ms.com I want to return North and East.

This isn't currently working as all sites are returned when published.

Any ideas would help.

Thanks,

Bob

[v-chuncz-msft · Accepted solution]

@BeginnerBob,

The following DAX filter expression works for me.

SEARCH(", " & USERPRINCIPALNAME() & ",", ", " & [UserID] & ",", 1, 0 ) > 0