CUBESET - Dimension filter(s)|Power Pivot|Excel Forum|My Online Training Hub

Hello All,

I seek to create a Cubeset of a department dimension.  The Cubeset need be filtered by Company and a specified range of Departments.

Is the following MDX moving in the right direction? Regrettably I cannot post the workbook as it work-related (data sensitivity).

= Cubeset("Connection", "{Filter([Company].[Company].&CompanyA,

[Department].[Department Code].Members,

[Department Code].Membervalue >= "200" AND [Department Code].Membervalue <= "250")},

"Dept")

Am using Office 365.

Many thanks for your consideration.

Kind regards,

David