Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

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 ...
Need Help
v-lili6-msft's avatar
v-lili6-msft
Community Support
6 years ago

HI, Anonymous 

Try to use ALLSELECTED instead of ALLEXCEPT in the formula like:

Cumulative Delivered =
CALCULATE (
    COUNT ( 'Tasks'[MilestoneDate] ),
    FILTER (
        ALLSELECTED ( 'Tasks' ),
        Tasks[ProjectName] = MAX ( Tasks[ProjectName] )
            && NOT ( NOT ( 'Tasks'[TaskIsMilestone] )
            && ( Tasks[TaskMilestoneStatus] ) = 1 )
            && 'Tasks'[TaskFinishDate] <= MAX ( 'Tasks'[TaskFinishDate] )
    )
)

If not your case, please share a simple sample pbix file for us have a test.

 

Regards,

Lin