cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
BeginnerBob Frequent Visitor
Frequent Visitor

Row Filter on Role

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

 

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Row Filter on Role

@BeginnerBob,

 

The following DAX filter expression works for me.

SEARCH(", " & USERPRINCIPALNAME() & ",", ", " & [UserID] & ",", 1, 0 ) > 0
Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
1 REPLY 1
Community Support Team
Community Support Team

Re: Row Filter on Role

@BeginnerBob,

 

The following DAX filter expression works for me.

SEARCH(", " & USERPRINCIPALNAME() & ",", ", " & [UserID] & ",", 1, 0 ) > 0
Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.