cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted

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.

1 ACCEPTED SOLUTION

Accepted Solutions
Power BI Team TaylorClark
Power BI Team

Re: Intellisense bug in Power BI Desktop

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

View solution in original post

4 REPLIES 4
Moderator v-sihou-msft
Moderator

Re: Intellisense bug in Power BI Desktop

@marcorusso

 

We reproduced this issue.

 

2.PNG

 

We have reported it internally. 

 

Regards,

Microsoft v-haibl-msft
Microsoft

Re: Intellisense bug in Power BI Desktop

@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

Power BI Team TaylorClark
Power BI Team

Re: Intellisense bug in Power BI Desktop

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

View solution in original post

Re: Intellisense bug in Power BI Desktop

Thanks!

Helpful resources

Announcements
New Ranks Launched March 24th!

New Ranks Launched March 24th!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power BI Community!

‘Better Together’ Contest Finalists Announced!

‘Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

Arun 'Triple A' Event Video, Q&A, and Slides

Arun 'Triple A' Event Video, Q&A, and Slides

Missed the Arun 'Triple A' event or want to revisit it? We've got you covered! Check out the video, Q&A, and slides now.

Top Solution Authors
Top Kudoed Authors