21 Replies Latest reply: Mar 13, 2018 2:51 PM by David Le RSS

    Counts Showing Incorrectly in charts

    David Le

      I have a measure where I use an expression of


      Count ({< [Term] = {'Yes'}, [Term Reason] -= {'Unknown'}>} EmployeeID)


      When I use this in a pivot table and group by YearMonth I get a total of 791 records which is correct.


      When I use the same expression in a KPI I get 784 records.  Looks like its removing duplicate employeeIDs.  Duplicate records can occur since an employee can be termed more than once in a given period.


      I am not sure what is going on since I am using the same master measure in both types of charts.


      Any ideas why it would do this?