Error with a measure using a date filter

[Andy_W_UK]

Hi everyone,

I am a novice and trying to create a measure which filters records where a date column called ETD has no date entry.
The column is formatted as date.
I am getting an error that the syntax is incorrect, so please can someone tell me what is wrong?

m total tasks no etd =

CALCULATE( COUNTA('SDT Clarity Tasks'[ID]) ,

KEEPFILTERS('SDT Clarity Tasks'[Phase] = "Delivered"),

KEEPFILTERS('SDT Clarity Tasks'[ETD] = BLANK),

KEEPFILTERS('SDT Clarity Tasks'[Customer] <> "SAP Concur"))

Many thanks !

[jdbuchanan71 · Accepted solution]

When you use BLANK it is looking for open and close paren after it so BLANK():

m total tasks no etd =
CALCULATE (
    COUNTA ( 'SDT Clarity Tasks'[ID] ),
    KEEPFILTERS ( 'SDT Clarity Tasks'[Phase] = "Delivered" ),
    KEEPFILTERS ( 'SDT Clarity Tasks'[ETD] = BLANK () ),
    KEEPFILTERS ( 'SDT Clarity Tasks'[Customer] <> "SAP Concur" )
)

[jdbuchanan71 · Accepted solution]

When you use BLANK it is looking for open and close paren after it so BLANK():

m total tasks no etd =
CALCULATE (
    COUNTA ( 'SDT Clarity Tasks'[ID] ),
    KEEPFILTERS ( 'SDT Clarity Tasks'[Phase] = "Delivered" ),
    KEEPFILTERS ( 'SDT Clarity Tasks'[ETD] = BLANK () ),
    KEEPFILTERS ( 'SDT Clarity Tasks'[Customer] <> "SAP Concur" )
)

[Andy_W_UK · Accepted solution]

Simple when you know how I guess !

Thank you, it is now working fine which is great.