Forum Discussion

happy30's avatar
happy30
Frequent Visitor
3 years ago
Solved

DAX Expression in Manage Roles

Hi Team,   I want to know if we can use "SEARCH" funtion like SQL "A%" in DAX expression in Manage roles. If yes, can anyone please assist me in this use case: There is one filter with "Full Names...
DAX
Manage role
  • Jihwan_Kim's avatar
    Jihwan_Kim
    3 years ago

    Hi,

    I am not sure how your datamodel looks like, but I tried to create a sample pbix file like below.

    Please check the Manage roles and View as in the attached pbix file.

     

     

Jihwan_Kim's avatar
Jihwan_Kim
Super User
3 years ago

Hi,

I am not sure how your datamodel looks like, but I tried to create a sample pbix file like below.

Please check the Manage roles and View as in the attached pbix file.

 

 

  • happy30's avatar
    happy30
    Frequent Visitor
    3 years ago

    Hi Jihwan,

    Thank you so much!

     

    The Solution worked. Can I please confirm one more thing in this syntax, if this LEFT function will filter only uppercase A, B, C or it can filter both uppercase or lowercase i.e it is case insensitive.

    • Jihwan_Kim's avatar
      Jihwan_Kim
      Super User
      3 years ago

      Hi,

      Thank you for your message.

      It is not case sensitive.

      If your datamodel needs to be case sensitive, I suggest having an index column or grouping column in Power Query Editor, and then use DAX formula in Manage roles.

      I hope it helps.

      Thank you.