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.

    mdxSample

    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:

    mdxSample2

    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 (

    [DATUM].[Kalender].[Datum].Members,

    [Measures].[Leistung]= (

    [DATUM].[Kalender].[Jahr].&[2021],

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

    [DATPKT].[Medium].[Medien].&[Erdgas],

    [Measures].[Leistung]

    )

    ).Item(0).Name

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

    fixed element 2021 results in 2020

    mdxSample3

    • 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?

    mdxSample4

  • 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