US and Worldwide: +1 (866) 660-7555
Results 1 to 2 of 2

Thread: Where condition for Measure in MDX Query

  1. #1
    Join Date
    Jun 2013
    Posts
    1

    Post Where condition for Measure in MDX Query

    Hi All,

    I have a MDX Query as starts below
    SELECT NON EMPTY { [Measures].[Actual] } ON COLUMNS, NON EMPTY
    I need a Values where [Measures].[Actual] is not equal to Zero.
    Please let me know the Code for the same and help me.

    Thanks in Advance.

    Mahi

  2. #2
    Join Date
    Sep 2011
    Posts
    26

    Default

    You should use the function Filter() in the "ON ROWS" statement.

    SELECT NON EMPTY {[Measures].[Actual]} ON COLUMNS,
    NON EMPTY Filter([Example Dimension].Members, [Measures].[Actual] <> 0) ON ROWS
    FROM ...

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •