Distinct Count to ignore blank in a column not correct

[Invesco]

Hi Expert

I cannot see the where the error is in the followng DAX is not ignoring the blanks the count

Distinct No Blanks = CALCULATE(DISTINCTCOUNT(shc_shingrix_practice[crm_call_name]),FILTER(shc_shingrix_practice,shc_shingrix_practice[crm_call_name] <> ""))

[Kishore_KVN · Accepted solution]

Hello @Invesco ,

you have to provide space between double inverted commas. 

Your measure should look as below:

Distinct No Blanks = CALCULATE(DISTINCTCOUNT(shc_shingrix_practice[crm_call_name]),FILTER(shc_shingrix_practice,shc_shingrix_practice[crm_call_name] <> " "))

As an alternative you can also try 

Distinct No Blanks = 
IF(ISBLANK(shc_shingrix_practice[crm_call_name]), BLANK(),
CALCULATE(DISTINCTCOUNT(shc_shingrix_practice[crm_call_name])))

If this post helps, then please consider accepting it as the solution to help other members find it more quickly. Thank You!!