Hi all,
I am trying to create a calculated measure that finds the difference between two measures by using the following mdx query
WITH MEMBER [Measures].[Available]
AS ([Measures].[Capacity days] ,[Project].[Projects by Name].[All],[Project].[Projects by Code].[All])
- ([Measures].[Worked Days] ,EXCEPT([Project].[Projects by Name].[Project].MEMBERS,
[Project].[Projects by Name].[Project].&[1214]),[Version].[Version].[Combined],[Charge].[Charge].[All])
and in case of second measure Worked Days i want to access it with respect to all projects except one ,so in this case am using EXCEPT function , which results in the error
" The function expects a string or numeric expression for the argument. A tuple set expression was used"
Is there any other way to perform this operation?