Create conditional calculated measure

[rsfm]

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?

Thanks.

[timrichardson]

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