Use OR with Cubest

[deharris]

Looking for help on a CUBESET formula. I'm trying to use an OR statement in a CUBSET formula with multiple expressions, one of which is the .children result. I need an OR statement or some way to combine the choices two items in one expression, single items in other expressions and the eventual children of a final expression. I think it's something like this but I can't get it to work. Goal is to use a CUBERANKEDMEMBER formula to view the Brand children of Division1 whether they exist in Month1 or Month2. I have some flexibility in that I can select the months in a slicer as well but I've no luck combining slicer selections with member expressions in a CUBESET even when naming their range and referencing them. It seems to work with CUBEVALUE but not CUBERANKEDMEMBER. TY for any help!

CUBESET("ThisWorkbookDataModel","{([Programs].[Months].[Month1]* [Programs].[Months].[Month2]),[Programs].[Division].[Division1],[Programs].[Brand].Children)}","Brands",3)

 

[deharris]

UPDATE: I can get this formula to list all the brands that fall in both months but it duplicates brands that fall in both. I'm looking for a solution that shows whether brands fall in either month1 or month2 (a distinct list) as opposed to a full list of all with duplicates.

CUBESET("ThisWorkbookDataModel","({[Programs].[Months].[Month1],[Programs].[Months].[Month2]},([Programs].[Division].[Division1],[Programs].[Brand].Children))","Brands",3)