5 Replies Latest reply on Feb 1, 2019 10:28 AM by Tanya McBride

    Why are COUNTD values 1 off?

    Tanya McBride

      For COUNTD calculations, I am getting COUNTD+1 (see data source or even view data from the measure value itself).

       

      Even if I remove aggregate measure, COUNTD for Closed is still off:

       

       

      In packaged workbook, I removed most of the data from the 'Dummy Data' but included info like some of other calculations in used in combination the SQL union query and <including fixed share serial calc used to filter for qualified while still including opened and closed categories> behind logic (in case part of the issue or a better solution lies in the logic).

       

      My temporary (no logic) fix works but I would really like to learn and understand why this is happening.

       

      Explanations or ideas GREATLY appreciated!