3 Replies Latest reply on Sep 30, 2016 9:45 AM by Joe Oppelt

    Summing a distinct count

    Haley Brun

      Hello,

       

      I am having an issue summing a distinct count over a period of time. The measure I am working with is an if statement that outputs a 'Name' when the statement is true. The if statement is true maximum three times per day.  I add the measure to the table as a distinct count and the count is accurate for the day, with a count of 1, 2 or 3. When removing the day level of granulatiry to see the sheet on a monthly basis, the measure is not summed for the month. How can I make the distinct count summed over any time period greater than day?

       

      I'd appreciate any help!