MDX Filter() for a calculated measure

  • Hi folks,

    I am still quite new to MDX and have severe problems with the following task (beg your pardon for German language):

    The measure [Leistung] is aggregated on the database as max().

    Another, calculated measure [Leistung Zeitpunkt] is needed , wich delivers the date belonging to the maximum-value.


    I have tried to achive this with a filter on Date-Dimension, but it delivers only the very first non-empty element of Date-dimension:


    Thanks in advance for any hint.

    Bests, Matze

    • This topic was modified 3 weeks, 3 days ago by  MatzeR.
  • I guess, the problem lies in the tuple. By using fixed elements you retrieve a correct result for this case, i.g.

    Filter (


    [Measures].[Leistung]= (


    [DATPKT].[Funktion].[Ebene 2].&[LG],





    But allready an incomplete repclacement with .CurrentMember leads to incomprehensive results:

    fixed element 2021 results in 2020


    • This reply was modified 3 weeks, 3 days ago by  MatzeR.
  • A small step further on now, it is not the tuple itself.

    It gives back the correct value as you can see in measure [LogicalExprTuple].

    But this obviously does not work in the Filter-function.

    Is there any restriciton known?


  • Sorry, this is urgent to me, therfore I have posted this issue in the MS Q&A-Forum

Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply