Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

After Oct 2021 update Distinctcountnoblank inot working.

Hi,

 

After Updating Oct-21 Version. Distinctcountnoblank dax is not working. Not getting option to select any cloumn. Pleaseresolve the issue

 

Regards

Manish Kumar Juneja

Status: Delivered
Comments
edhans
Super User

This may be an issue with the new Intellisense engine. Try the measure anyway. I've seen similar with certian options of the CONVERT() function. Still works, just shows as invalid syntax in the editor.

v-cazheng-msft
Community Support
Status changed to: Investigating

Hi @juneja_60 

 

Similar issue posted in  DAX IntelliSense October 2021 Crash - Microsoft Power BI Community. In there, you can see the member Taylor Clark from Power BI Team who you can reach out to with your problems. 

 

 

Best Regards,

Community Support Team _Caiyun Zheng

v-cazheng-msft
Community Support
Status changed to: Accepted
 
edhans
Super User

FWIW, it does work. No measures were broken. Just some of the intellisense.

v-cazheng-msft
Community Support

@juneja_60 

 

Our product team has made some fix on Intellisense issue. And there is a newly released Power BI Desktop, please try it to check whether your issue can be resolved with it. 

Download Microsoft Power BI Desktop from Official Microsoft Download Center

 

Best Regards,

Community Support Team _Caiyun Zheng

v-cazheng-msft
Community Support
Status changed to: Delivered
 
georgerizk
Employee

DistinctcountNoBlank is working fine with number, but still with text acting exactly like distinctcount function.
for more explanation , please check the following short video
https://www.youtube.com/watch?v=Tl56PDF0aIc