How do I use match regex for multiple values?

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. *’

)
)

Hi,

The parenthesis is a reserved symbol in the regex, so you need to escape it. Please, check the following adjustment:

Aggregate(
Filter(
[Merchants].[Merchants].Members,
[Merchants].CurrentHierarchyMember.Name
MATCHES ‘.* Option \(A\).* |.* Option \(B\). * |.* Option \(C\). * |.* None. *’

)
)

Kindly,
Janis, eazyBI support