Cubevalue filtering with wildcardsd in Excel

Question

Hi,

I converted a pivot table to formulas with the OLAP Tools > Convert to Formulas option and now I want to filter down the cubevalues to only count if a predefined value that lives in a cell exists in the Rule field. i.e "RULE1" or "RULE66". (table below)

I've tried creating a cubeset with wildcards and with the filter function but nothing works. I could really use some help!

EXAMPLE OF THE CUBEVALUE FORMULA

=CUBEVALUE("ThisWorkbookDataModel","[Measures].[Count of TransIds]","[Table1].[Rule].&[RULE66|RULE42|RULE4|RULE67|RULE50|]",{"[Table1].[Status].&[B]","[Table1].[Date].&[2023-05-24T00:00:00]")

I'd like to be able to create something like this:

=CUBEVALUE("ThisWorkbookDataModel","[Measures].[Count of TransIds]","[Table1].[Rule].&[*** A1 ***]",{"[Table1].[Status].&[B]","[Table1].[Date].&[2023-05-24T00:00:00]")

Where A1 = RULE66 or RULE4 or any of the rules that are part of the Rule Field

Thanks in advance for your help

Laura