I have a measure for returning the number of overdue issues per issuetype, which is great. However it returns issues that have a due date of today and I only want to return issues with due dates in the past.
Can anyone help me update the below? I assume its something to do with the ‘Now’ function, but just can’t seem to get something that works.
[Measures].[Issues with due date] >0 and
isempty([Measures].[Issues resolved]) and
DateCompare([Measures].[Issue due date],Now())<0