Count function on direct query

Anonymous · ‎05-27-2020

I want to use count function in direct query mode.

I'm unable to use it. The formula does not return an error.

Measure = COUNT('Bölge Yöneticisi'[Bölge Yöneticisi Düzey 01])

when i try to use it on chart I'm getting this error.

v-eachen-msft · ‎05-27-2020

Hi @Anonymous ,

What's the version of your Power BI desktop? You could update to the latest version and check if it works.

If this problem still exists, to get faster and better technical support for this issue, you may directly create a support ticket.

Community Support Team _ Eads
If this post helps, then please consider Accept it as the solution to help the other members find it.

Anonymous · ‎05-29-2020

Hi @v-eachen-msft
My pbi desktop version is May 2020

Actually I want to get information about this. When using Direct Query Mode, Count function must be working, right ?

If it is a problem about my case then i would create a ticket.

amitchandak · ‎05-27-2020

@Anonymous , which Database you are facing this issue

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube