Sign in
Microsoft.com
 
Microsoft
 
 
 

locked
MDX Query returns Calculated Measure Error as : The function expects a string or numeric expression for the argument. A tuple set expression was used RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    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?

    Thursday, August 14, 2014 6:41 AM