Forum Discussion
Error with a measure using a date filter
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 !
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" ) )
2 Replies
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" ) )