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?
Is it possible that YearMonth and EmployeeID are coming from different tables?
Same table.
Did you try this?
Sum(Aggr(Count ({< [Term] = {'Yes'}, [Term Reason] -= {'Unknown'}>} EmployeeID), YearMonth))
I tried that before I posted and yes that works but why would it do this.
Doesn't make sense
My bad !
if([Term] = 'Yes' and [Term Reason] <> 'Unknown',Count ( EmployeeID) )
I agree... but I don't really have a view into what you are seeing... so difficult to comment...
Right, there are instance where I want to group by other dimensions, that is why I kept it generic. Thanks for the help today
For some reason that does not even give me a value.
Can u please share a sample app?
Unfortunately I can't since this is real data.