Scope using MeasureGroupMeasures() and Hierarchy level

  • Trying to evaluate all levels rather than a specific level. Is this possible? The example below is not working for me.

    Basically, when level > 1, we want all measures in the measure group to be set to null else display the measures.

    SCOPE(MeasureGroupMeasures("Marketing Cost"),[Enrollment Device].[Enrollment Device Hierarchy].AllMembers );

    This = IIF( [Enrollment Device].[Enrollment Device Hierarchy].currentmember.level.ordinal < 2

    ,MeasureGroupMeasures("Marketing Cost")

    ,NULL );

    END SCOPE;

Viewing 0 posts

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