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


      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




      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?