Forum Discussion

ImaginedCloud's avatar
ImaginedCloud
Frequent Visitor
7 years ago
Solved

Direct Query COUNTBLANK Alternative.

I need to be able to Count the number of rows in a column that are NULL In Direct Query, ultimately embedded. 

 

COUNTBLANK function does not work with Direct Query. 

 

Any Ideas on a work around? I really dont want to add another column.

 

Need Help
  • TomMartens's avatar
    TomMartens
    7 years ago

    Hey,

     

    you can try this mesure

    cnt BLANK = 
CALCULATE(
    COUNTROWS('countblank')
    ,FILTER(
        'countblank'
        ,'countblank'[amount] = BLANK()
    )
)

    Here is a little screenshot

     

    Hopefully, this is what you are looking for.

     

    Regards,
    Tom

2 Replies

  • TomMartens's avatar
    TomMartens
    Super User
    7 years ago

    Hey,

     

    you can try this mesure

    cnt BLANK = 
CALCULATE(
    COUNTROWS('countblank')
    ,FILTER(
        'countblank'
        ,'countblank'[amount] = BLANK()
    )
)

    Here is a little screenshot

     

    Hopefully, this is what you are looking for.

     

    Regards,
    Tom