This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(294.40000000000003, 54%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EM%3C/text%3E%3C/svg%3E)
Hello,
I am still quite new to MDX and need a measure, wich gives back a corresponding date.
The approach with filter() works properly as long as the tuple is defined by fixed elements.
But changing to CurrentMember leads to wrong results. Does this need just a simple modification or a total different approach?
Thanks in advance for any help.
Bests, Matze
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(32, 95%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAS%3C/text%3E%3C/svg%3E)
Try Filter ( (existing [Date].[Calender].[Date]) as [DaysSet], [Measures].[MaxCapacity] = Max ( [DaysSet], [Measures].[MaxCapacity] ) ).Item(0).Name
Thank you very much Alexei for your help, it works and gives back correct results.
This is more than a "simple modification", interesting to see that there can be a reference to the set part inside the logical part of Filter function.
Unfortunately the performance is a bit weak.
That was a first midnight approach, so no wonder it can be suboptimal :) The source of the performance problem is obvious: what is saved as the set alias before the Filter loop is a list of individual relevant dates, and MaxCapacity for them is computed within the loop, quite possibly for each iteration. What should really be saved is the value of the MaxCapacity measure for the current cell. That'd be trivial in DAX with a var, but in MDX it'll probably require something hackish exploiting the fact that a set could consist of a single tuple.
Question over questions: do you might have an explanation why the CurrentMember does not work? Can DAX be used against a mulitdimensional modell? As far as I know MDX can be used against tabular.
When Filter calculates the expression for a member of the set of Date.Calender.Date, this member is the current member of the Date.Calender hierarchy. This is what makes it problematic to obtain the total value of the measure for the set within the Filter to do the comparison.
MD cubes can be queried with DAX, this is what makes e.g. Power BI's live connection to MD cubes possible.
In the meantime I've come up with a hackish candidate:
Iif ( IsEmpty ( ([Measures].[MaxCapacity]) as hack.Item(0) )
, null
, Filter ( existing [Date].[Calender].[Date]
, [Measures].[MaxCapacity] = hack.Item(0)
).Item(0).Name
)
Thanks a lot for your answers. There is still a lot to learn...
The result of the modified formula is allways the first date in the period of time.
Well that's a pity. I tried to adapt a hack found at https://bigorakine.wordpress.com/2009/06/05/set-alias-in-iif-statement/, but obviously something went wrong. Should've kept the explicit reference to Date.Calender.CurrentMember in the aliased tuple, perhaps.