Forum Discussion

BeginnerBob's avatar
BeginnerBob
Frequent Visitor
8 years ago
Solved

Row Filter on Role

Hi,   I have a column labelled UserID in my Site dimension which has many user accounts i.e. [email protected], [email protected] etc.   I want to have a DAX expression which searches the string and filters t...
Need Help
  • v-chuncz-msft's avatar
    v-chuncz-msft
    8 years ago

    BeginnerBob,

     

    The following DAX filter expression works for me.

    SEARCH(", " & USERPRINCIPALNAME() & ",", ", " & [UserID] & ",", 1, 0 ) > 0
v-chuncz-msft's avatar
v-chuncz-msft
Community Support
8 years ago

BeginnerBob,

 

The following DAX filter expression works for me.

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