cube set expression

[ruthhacche]

I am struggling with my cibeset when I have more than one part to the expression.

I can get the following to both work to create a filtered list of orderIDs
=CUBESET("Power BI - SALES","[Calendar].[FiscalYear].&[2021]*[ORDERS].[ID SFC order].children","OrderIDS")

=CUBESET("Power BI - SALES","[CUSTOMER].[ID SFC Account].&[001b000000UUchgAAD]*[ORDERS].[ID SFC order].children","OrderIDS")



But I cannot get both red filters to apply because i do not know the syntax - any advice to where I can learn how to do this?

=CUBESET("Power BI - SALES","[CUSTOMER].[ID SFC Account].&[001b000000UUchgAAD]*[Calendar].[FiscalYear].&[2021]*[ORDERS].[ID SFC order].children","OrderIDS")

 

[ruthhacche]

I have solved it!!!!

=CUBESET("Power BI - SALES"," ([CUSTOMER].[ID SFC Account].&[001b000000UUchgAAD],[Calendar].[FiscalYear].&[2021]) *[ORDERS].[ID SFC order].children","OrderIDS")