Forum Discussion
cdfizz17
3 years agoFrequent Visitor
DAX Measure - Graph Active Cases Over Time
Hello, I'm writing a measure to calculate the total "active" help desk cases at any point in time. Cases are "active" between their [EntryDate] and [CloseDate] inclusive. I want to graph thi...
Jihwan_Kim
3 years agoSuper User
- cdfizz173 years agoFrequent Visitor
Thank you for the answer. Unfortunately, there is still an issue.
On 17th May, there were 45 active cases. Using ALLSELECTED, only 19 are counted. There are 26 missing from the total. They are filtered out by the date slicer, because the [EntryDate] is before 17th May...