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!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
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
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 39 | |
| 38 | |
| 38 | |
| 28 | |
| 27 |
| User | Count |
|---|---|
| 124 | |
| 88 | |
| 73 | |
| 66 | |
| 65 |