Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
Solved! Go to Solution.
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
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
Great! Yep works.
Thanks for the Help!
-Zach