Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Create conditional calculated measure

  1. #1
    Join Date
    Aug 2016

    Question Create conditional calculated measure

    Dear all,

    I am trying to build a particular chart... I need to filter on measures (other than just selecting "Greater than"/"Less than" some constant). That is why I am trying to do that through MDX expression.

    I created an example where I have 8 rows and, for each one, I have columns QLIQi and QREFi. I want to show in one chart sum of (QLIQ-QREF)i where QLIQi > QREFi.

    I tried to create a calculated measure using something like this, but does not work:

    IIf ([QLIQ] > [QREF], [QLIQ]-[QREF], 0)

    Could anyone please advise me what is my mistake?


  2. #2


    well, firstly I think you need to specify a dimension. Such as IIf(Measures.QLIQ > Measures.QREF ...)
    MDX is not a short journey.

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.