Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Amend current DAX Measure to Ignore blanks

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

 

  • Kishore_KVN's avatar
    Kishore_KVN
    3 years ago

    Hello Anonymous ,

    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!!

2 Replies

  • Kishore_KVN's avatar
    Kishore_KVN
    Icon for Solution Sage rankSolution Sage
    3 years ago

    Hello Anonymous ,

    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!!

  • ThxAlot's avatar
    ThxAlot
    Icon for Super User rankSuper User
    3 years ago
    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