Remove shared members from XRANGE

@REMOVE

Summary

@REMOVE in @XRANGE not working as expected

Content

Hi experts,

we have the following custom calculation which counts the members of Period dimension in a given range:

@XRANGE(
@CURRMBR(ContractYear)->@CURRMBR(Period),Year->Period)

The second part of the XRANGE function is always a fix value based on variables. The issue comes because there is a new set of shared members inside the Period dimension (new hierarchy in blue):

Period

|_ Year Total

    |_ Jan

    |_ Feb

    ....

    |_ Dec

|_ Year Total_Quarter

    |_Q1

        |_ Jan (Shared)

        |_ Feb (Shared)

          ....

    |_Q4 

       ....

        |_ Dec  (Shared)

Now, the custom calculation adds 12 members on the XRANGE function everytime the year changes: