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.

     

     

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.