
New Member
Dashboards
Power Query
Power Pivot
Power BI

May 9, 2020

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


November 8, 2013

Hi David,
Have you seen this article about CUBE functions?
https://www.myonlinetraininghu.....-functions
You can find a few examples here:
1 Guest(s)
