Forum Discussion

Orstenpowers's avatar
Orstenpowers
Post Patron
6 years ago
Solved

Manage roles

Dear all,

 

I am trying to define/ manage different roles.

As default, Power BI states e.g. [Country Name] = "Italy".

 

Is it also possible to replace the "=" with a character for "contains"? 🤔

 

My internet research was w/o results...😐

Need Help

6 Replies

    • Orstenpowers's avatar
      Orstenpowers
      Post Patron
      6 years ago

      Hi Greg,

       

      Thx for your feedback!

       

      But which expression do I have to use to state at the "Manage roles" section to define e.g. "Country" contains "Nether"???

    • Orstenpowers's avatar
      Orstenpowers
      Post Patron
      6 years ago

      Dear v-frfei-msft,

       

      Thank you for your hint, but I get following message from Power BI: 🤔

      • v-frfei-msft's avatar
        v-frfei-msft
        Community Support
        6 years ago

        Hi Orstenpowers ,

         

        Remove the "=".

        SEARCH ( "Italy", [Country Name], 1, BLANK () ) <> BLANK ()