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
User | Count |
---|---|
85 | |
74 | |
71 | |
68 | |
56 |
User | Count |
---|---|
96 | |
94 | |
92 | |
78 | |
71 |