MDX-How to use the Filter function in a SCOPE statement
Q: Can you use the Filter function in a SCOPE statement?
A: Yes you can. Filter function is allowed inside SCOPE function. Example of how you can use FILTER function inside SCOPE function provided below:
SCOPE ( Filter([Date].[Calendar].[Month].MEMBERS, [Date].[Calendar].Properties("Month of Year") = "January") );
Measures.[Amount] = 10;
END SCOPE;