DAX for filtering Blanks from a measure

[Carrhill]

Hello,

I have the below measure which filters my data by date.  It doesn't work as expected becuase it returns a result when Date Column is Blank.   I need to add IF 'Table'[Date Column]<>BLANK , however that is returning errors.

Measure = CALCULATE (COUNT('Table'[Column]),FILTER('Table','Table'[Date Column]>=DATE(2021,01,29)&&'Table'[Date Column]<=DATE(2023,02,03)))

Any help would be appreciated! 

[v-luwang-msft]

Hi @Carrhill ,

Has your problem been solved, if so, please consider Accept a correct reply as the solution or share your own solution to help others find it.

Best Regards
Lucien

[v-luwang-msft]

Hi @Carrhill ,

In my test ,it not question,could you share your sample data?Remember to remove confidential data.

Best Regards

Lucien

[amitchandak]

@Carrhill , Try like

Measure = CALCULATE (COUNT('Table'[Column]),FILTER('Table','Table'[Date Column]>=DATE(2021,01,29) && 'Table'[Date Column]<=DATE(2023,02,03) && not(isblank('Table'[Date Column])) ))

[Carrhill]

Hi @amitchandak , it didn't work 😞  No syntax error, but it didn't filter the data.