Forum Discussion
Filtering Cumulative count by date
I'm working my way through the creation of a new report, with significant help from members of this group. I need to produce a Line and Column visual, showing, cumulatively, the number of project ...
What I omitted to say was that the Cumulative Delivered DAX results in a count of all tasks in the project plan, rather than a count of the Milestones (TaskIsMilestone - a True/False MSProject field). The Line code (below) works, giving a correct result of 43, whereas the Delivered count returns 274.
Cumulative Milestones =
CALCULATE (
COUNT( 'Tasks'[MilestoneDate] ),
FILTER (
ALLEXCEPT( 'Tasks',Tasks[ProjectName]),
NOT( NOT( 'Tasks'[TaskIsMilestone]))
&& 'Tasks'[TaskFinishDate] <= MAX ('Tasks'[TaskFinishDate])
))