Running total with filter

Hi Anonymous ,

Please check if this is what you want:

1. Assume that all tasks are assigned on 2018/1/1.

2. Create a Calendar table.

Calendar = CALENDAR(DATE(2018,1,1),DATE(2018,12,31))

3. Create relationship.

4. Create measures like so:

Measure = 
VAR CurrentDate =
    MAX ( 'Calendar'[Date] )
VAR CurrentDueDate =
    MAX ( 'Table'[Due Date] )
VAR CurrentActualDate =
    IF (
        MAX ( 'Table'[Actual Completion Date] ) = BLANK (),
        TODAY (),
        MAX ( 'Table'[Actual Completion Date] )
    )
VAR DD =
    IF (
        CurrentDueDate <= CurrentActualDate
            && CurrentDate <= CurrentDueDate,
        CurrentDueDate,
        IF (
            CurrentDueDate <= CurrentActualDate
                && CurrentDate >= CurrentDueDate
                && CurrentDate <= CurrentActualDate,
            CurrentActualDate,
            IF (
                CurrentDueDate > CurrentActualDate,
                CurrentActualDate,
                IF ( CurrentActualDate = TODAY (), CurrentDate )
            )
        )
    )
VAR Is1 =
    IF ( DD = CurrentDate, 1, IF ( DD <= MAX ( 'Calendar'[Date] ), 1, 0 ) )
RETURN
    Is1

Running total = 
CALCULATE ( COUNT ( 'Table'[Task] ), ALLSELECTED ( 'Table' ) )
    - CALCULATE (
        SUMX ( 'Calendar', [Measure] ),
        FILTER (
            ALLSELECTED ( 'Calendar' ),
            'Calendar'[Date] <= MAX ( 'Calendar'[Date] )
        )
    )

For more details, please check the attached PBIX file.

If I understand it wrong, please let me know.

Best Regards,

Icey

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.