Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes! Register now.
The following DAX code is correct and accepted in Power BI, but IntelliSense marks it as syntax error after the first argument:
Subscription =
ALLNOBLANKROW ( Subscriptions[First List], Subscriptions[Cancel Type], Subscriptions[Status], Subscriptions[StatusCode], Subscriptions[SubscriptionStateKey] )
It seems the ALLNOBLANKROW syntax is not correct in the IntelliSense parser.
Solved! Go to Solution.
Thanks for catching this Marco! Sorry about that :). Turns out the implementation of ALLNOBLANKROW didn't match the original spec when the update to intellisense ships we'll fix the MSDN documentation to include the extra parameter(s) as well
Thanks for catching this Marco! Sorry about that :). Turns out the implementation of ALLNOBLANKROW didn't match the original spec when the update to intellisense ships we'll fix the MSDN documentation to include the extra parameter(s) as well
The fix will be hopefully available in Sep 2017 version of Power BI Desktop. If not, it will be fixed in Oct 2017 version of Power BI Desktop.
Best Regards,
Herbert
Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!
Check out the September 2025 Power BI update to learn about new features.