Search code examples
ssasmdx

How to use TopPercent and TopCount in CalculatedMemebers?

Is it possible to use TopPercent or TopCount in CalculatedMembers in a MDX query?

Solution

  • Yes, there's basically no limitation in calculated member formula. But if your question is about having a calculated member of type 'set', then you should use a SET instead (WITH SET ...) or if you're using icCube a function (WITH FUNCTION...)

    Cheers.