Amend current DAX Measure to Ignore blanks

[Invesco]

Hi Experts

How would you amend the following to ignore blanks from the count from 

shc_shingrix_practice[crm_call_name]

External HCO Count_ = 
        COUNTROWS(
            SUMMARIZE(shc_shingrix_practice,shc_shingrix_practice[crm_call_name],shc_shingrix_practice[parent_external_hco_code]))+0

[ThxAlot]

External HCO Count_ =
CALCULATE(
    COUNTROWS(
        SUMMARIZE(
            shc_shingrix_practice,
            shc_shingrix_practice[crm_call_name],
            shc_shingrix_practice[parent_external_hco_code]
        )
    ),
    NOT ISBLANK( shc_shingrix_practice[crm_call_name] )
) + 0

[Kishore_KVN · Accepted solution]

Hello @Invesco ,

Try below measure to achieve it.

External HCO Count_ = 
        IF(ISBLANK(shc_shingrix_practice[crm_call_name]),BLANK(),
COUNTROWS(            SUMMARIZE(shc_shingrix_practice,shc_shingrix_practice[crm_call_name],shc_shingrix_practice[parent_external_hco_code])))+0

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