Banding and Slicers

[SamualDaxter]

Hi Everyone,

I'm having an issue producing a graph that has a dynamic band as the Column series.

The DAX I'm using is as follows:

TaskPerfSum = 
VAR TaskSum =
    SUMMARIZECOLUMNS (
        Task[TaskID],
        Task[StartDateYearMonth],
        Task[StartDateYearMonthSortBy],
        "TotalDuration", SUM( Step[Duration] )
    )
VAR PeriodSum =
    SELECTCOLUMNS (
        ReportDuration,
        "StartNoOfDays", ReportDuration[StartNoOfDays],
        "EndNoOfDays", ReportDuration[EndNoOfDays],
        "ReportingPeriodDisplayName", ReportDuration[DisplayPeriodName],
        "SortPeriodBy", ReportDuration[SortBy]
    )
VAR results =
    FILTER (
        CROSSJOIN ( TaskSum, PeriodSum ),
            [TotalDuration] >= [StartNoOfDays]
            && [TotalDuration] <= IF ( ISBLANK ( [EndNoOfDays] ), 99999.99, [EndNoOfDays] )
    ) 
RETURN
    results

for the following model:

Task Step Model

And I have the following slicers:

Task Step Slicers

The problem is the TotalDuration and the Band Display Name do not update when a slicer (below task) is selected.

Any help/pointers would be much appreciated.

Thanks for your help.

Andy