As referring to code below, I am trying to find issues that matches either 4 of the options. But regex only can detect the value “None” because the value doesn’t have parentheses (). How can I use regex MATCHES that cater parentheses?
Aggregate(
Filter(
[Merchants].[Merchants].Members,
[Merchants].CurrentHierarchyMember.Name
MATCHES ‘.* Option (A).* |.* Option (B). * |.* Option (C). * |.* None. *’)
)