DAX not filtering from slicers

Anonymous — Wed, 03 Apr 2024 16:00:10 GMT

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

Re: DAX not filtering from slicers

lbendlin — Wed, 03 Apr 2024 23:32:22 GMT

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?

topic Re: DAX not filtering from slicers in DAX Commands and Tips

DAX not filtering from slicers

Re: DAX not filtering from slicers