CUBESET formulas with several slicers/filters

[j0nthn]

Hi,

I use the CUBESET formula to rank data ("Query") descending by a certain measure ("PIO"), using this formula:

=CUBESET("ThisWorkbookDataModel","[Data].[Query].children","Name",2,"[Measures].[PIO]")​

Now I know if I want to filter data for only one specific country, I can add it as so:

=CUBESET("ThisWorkbookDataModel","[Data].[Country].[USA]*[Data].[Query].children","All Queries + Country (ORDERS)",2,"[Measures].[PIO]")​

I have two questions:

1. If I want to add one more criteria to filter for the formula doesn't work, i.e. I want to rank "queries" for a certain "country" and in a certain "week" I try below formula, which doesn't seem to work. Is there any solution for this, so I can add X amount of filters/criteria?

=CUBESET("ThisWorkbookDataModel","[Data].[Week].[CW42]*[Data].[Country].[ID]*[Data].[Query].children","All Queries + Country (ORDERS)",2,"[Measures].[PIO]")​

2. Is there a way to directly insert a or several Slicers into the CUBESET formula? Like below formula which doesn't work

=CUBESET("ThisWorkbookDataModel","Slicer_Country*[Data].[Query].children","All Queries + Country (ORDERS)",2,"[Measures].[PIO]")
​

Many thanks in advance,
Jon