Exclude Values from CUBEVALUE Formula

[a68tbird]

Hello -
I would like to return a sum of sales for a particular sales property, for a particular month, but exclude 2 categories from the sales total. I can't seem to get the syntax correct for this. I've tried numerous variations of this:

=CUBEVALUE(
    "ThisWorkbookDataModel",
    "[Measures].[Sum of Sales]",
    "[Sales].[Property].[foo]",
    "[Calendar].[CurrentYM].[202306]",
    "FILTER(NOT(AND([Sales].[Category].[ExcludeCategory1]),([Sales].[Category].[ExcludeCategory2])))"
)

Any suggestions?
Thanks

 

[a68tbird]

Further to this, I have managed to figure out how to exclude one value from a member expression like this:

=CUBEVALUE(
    "ThisWorkbookDataModel",
    "[Measures].[Sum of Sales]",
    "[Sales].[Property].[foo]",
    "[Calendar].[CurrentYM].[202306]",
    CUBESET("ThisWorkbookDataModel",
    "except([Sales].[Category].[All].children,{[Sales].[Category].[ExcludeCategory1]})")
)

(the CUBESET formula portion can be stored as a Named Range, so that part of the formula can be somewhat simplified by just calling the named range).

However, I still can't figure out how to include a second value from the Category column.