DAX not filtering from slicers

[Anonymous]

Hi,

I have the following measure that is counting the correct number of projects, but when I select slicers the total figures do not change. I'm sure a quick fix but any help is appreicated, thanks!

ProjectsO.O.D =

VAR Precontolive =

    CALCULATE (

        DISTINCTCOUNT ( Project[ProjectID] ),

        Project[ProjectStartDate] < TODAY (),

        'Project Status'[ProjectStatusName] IN {"Pre-Contract"}

    )

VAR Livetodef =

    CALCULATE (

        DISTINCTCOUNT ( Project[ProjectID] ),

        Project[ProjectCompletionDate] < TODAY (),

        'Project Status'[ProjectStatusName] IN {"Live"}

    )

VAR Defectstoarc =

    CALCULATE (

        DISTINCTCOUNT ( Project[ProjectID] ),

        Project[ProjectCompletionDate] < EDATE ( TODAY (), -12 ),

        'Project Status'[ProjectStatusName] IN {"Defects"}

    )

RETURN

Precontolive + Livetodef + Defectstoarc

[lbendlin]

Please provide more details.  How are the slicer columns wired into your overall data model? Do they even have a chance to impact the result?