I have a measure that can be 0,50,70 or 100. When I filter on that measure's previous score=100 and current score less than 100, I only get 1 record (this particular record is correct) when I know I have many records that have changed in this way (based on a timeline report showing this measure's scores updated from 100 to a lower score on many records). Any nuances with these field types that I should consider or any idea why this is happening? I don't have a date filter or any other types of filters applied in addition to this one.
Already have an account? Login
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.