FILTER function on top of Measure RRS feed

  • Question

  • I would like to know whether below one returns right results since im getting Total Value

    select filter([Measure].[Amount],[Dim].[Attr].&[Value]) on 0

    from CUBE

    Friday, October 14, 2011 6:05 PM


  • filter([Measure].[Amount],[Dim].[Attr].&[Value])

    This is not the correct syntax.

    Remove the filter function:

    ([Measure].[Amount], [Dim].[Attr].&[Value])

    This syntax behave like an SQL WHERE clause.
    .&[Value] has to be a name of the attribute. Like .&[Yes] or .&[No] or whatever the values are in your case.

    Filter (MDX)

    Friday, October 14, 2011 7:41 PM