Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
try =-
instead of -=
same issue