Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric 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
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
86 | |
84 | |
66 | |
62 | |
61 |
User | Count |
---|---|
197 | |
118 | |
108 | |
78 | |
69 |