8 Replies Latest reply on Aug 5, 2015 6:05 AM by Sagar Tippe

    One user displays two times in the report  - issue with measure

    2973433

      Hi guys,

       

      My aim is to create a measure that shows Number of new users in the TimeHierarchy.

      So I use Distinct Count formula to get a number. My Fact UserTable has relation with Time like this:

      "DIM_DATE"."DTD_GID" between

      "FCT_USERS"."CUS_DATE_VALID_FROM_" and

      "FCT_USERS"."CUS_DATE_VALID_TO_"

       

      It works but there is one problem.

      if User has "startDate" in 2012 and "endDate" in 2013, then in report he is showed in both years but I want him display only in the year he started (2012).

      I cannot change relation between these tables because I need it for other purposes.

      Is there any solution (ie function) that will show user in only StartDate Year?