How to stop applying external Date[MMM-YYY] filter on measure

[Sharma0815]

Hi ALL,

I have a table contains my survey data and I mapped it with a Date table and I don't want to apply any value from my Date[MMM-YYYY] on my measure  created using survey table data.

Score =

CALCULATE (

DISTINCTCOUNT( Survey[responseid] ),ALL('Date','Date'[MMM-YYYY]),

FILTER ( Survey, Survey[category] = "Top2" && Survey[recordeddate] >= DATE(2020,11,1) )

)

[Anonymous]

If you want to completely ignore any filters on 'Date', then you write:

Score =
CALCULATE (
    DISTINCTCOUNT( Survey[responseid] ),
    KEEPFILTERS(
        Survey[category] = "Top2"
    ),
    KEEPFILTERS(
        Survey[recordeddate] >= DATE(2020,11,1) 
    ),
    ALL( 'Date' )   
)

Also, filtering by a full fact table, Survey, as you do in your code is not only bad practice from many points of view, but more importantly it slows down your code to a great extent and sometimes can indeed be dangerous. One should always only filter by columns that are really needed. There's too much theory behind the above rules to explain here. If you want to know more, you can look for articles on www.sqlbi.com or read the book "The Definitive Guide to DAX".