6 Replies Latest reply: Jul 12, 2017 8:23 AM by Wim Embrechts RSS

    Count ALL issue

    Wim Embrechts

      Hi,

       

      In a measure I'm making a count of the file numbers. This seems to be a distinct count.

      This is the measure that I'm using:

      count(DOSSIERNR)

       

      But how do I modify the measure so I also count the duplicate file numbers?

      I've been experimenting with some variations but without succes.

       

      Example:

       

      file number

      101

      102

      102

      103

      104

       

      The measure count(DOSSIERNR) results in 4 but I also need a measure that counts 5 in this case.


      Many thanks in advance for your assistance.

       

      Wim