Try Filter ( (existing [Date].[Calender].[Date]) as [DaysSet], [Measures].[MaxCapacity] = Max ( [DaysSet], [Measures].[MaxCapacity] ) ).Item(0).Name
MDX Filter function using CurrentMember (multidimensional)
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
1 additional answer
Sort by: Most helpful
-
Matze 21 Reputation points
2021-10-08T06:46:57.397+00:00 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.