Earn 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
User | Count |
---|---|
106 | |
89 | |
81 | |
76 | |
73 |
User | Count |
---|---|
112 | |
104 | |
96 | |
74 | |
66 |