6 Replies Latest reply on Feb 21, 2014 7:24 AM by Matt Lutton

    How to get a summed measure of the distinct count of a dimension?

    Eric Decker

      Hi all,

      I have an excel file in which we have multiple dimensions with the same measures that I need some help with getting an accurate sum.

       

      Essentially, I want to do a distinct count against the Grouping column and then get a sum rolled up against that distinct count. Using the below example, I only want to sum the # of Members once for each group and return that value. Using that logic and the below data set the sum I’m looking for would be “20” as opposed to “35”.

       

       

      I have attached a packaged workbook which already includes an extract in case a Distinct Count needs to be used.

      Please help!!

      -Eric