Forum Discussion

marcorusso's avatar
marcorusso
Icon for Most Valuable Professional rankMost Valuable Professional
9 years ago
Solved

Intellisense bug in Power BI Desktop

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.

General Comment
  • TaylorClark's avatar
    TaylorClark
    9 years ago

    Thanks for catching this Marco! Sorry about that :). Turns out the implementation of ALLNOBLANKROW didn't match the original spec :smileyhappy: when the update to intellisense ships we'll fix the MSDN documentation to include the extra parameter(s) as well

4 Replies

  • v-haibl-msft's avatar
    v-haibl-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    9 years ago

    marcorusso

     

    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

  • TaylorClark's avatar
    TaylorClark
    Icon for Power BI Team rankPower BI Team
    9 years ago

    Thanks for catching this Marco! Sorry about that :). Turns out the implementation of ALLNOBLANKROW didn't match the original spec :smileyhappy: when the update to intellisense ships we'll fix the MSDN documentation to include the extra parameter(s) as well