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

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

ImaginedCloud's avatar
ImaginedCloud
Frequent Visitor
7 years ago

Great! Yep works. 

 

Thanks for the Help!

 

-Zach