Forum Discussion

Cymbolz's avatar
Cymbolz
Helper III
8 years ago
Solved

COUNT function includes cells with text

Hello,   I am puzzled by the behavior of the DAX function COUNT.   Am expecting it to behave like Excel's count() function, in that it returns the count of cells with numbers but not text.    T...
  • v-jiascu-msft's avatar
    v-jiascu-msft
    8 years ago

    Hi Cymbolz,

     

    I have reported this issue to the Product Team to investigate more. I will update here later.

     

    Best Regards,

    Dale

Cymbolz's avatar
Cymbolz
Helper III
8 years ago

Thanks Greg_Deckler, glad it wasn't just me seeing this.

 

Would appreciate if a few others can confirm the same.

 

Thus, it would seem MS have changed the behaviour but not any documentation.  Wonder how many people wrote code relying on the previous functionality???  And maybe not even realise it's changed.

v-jiascu-msft's avatar
v-jiascu-msft
Microsoft Employee
8 years ago

Hi Cymbolz,

 

I have reported this issue to the Product Team to investigate more. I will update here later.

 

Best Regards,

Dale

  • v-jiascu-msft's avatar
    v-jiascu-msft
    Microsoft Employee
    8 years ago

    Hi, 

     

    The report ID is: 61341249.

     

    Best Regards,

    Dale

    • v-jiascu-msft's avatar
      v-jiascu-msft
      Microsoft Employee
      8 years ago

      Hi Cymbolz,

       

      The document will be updated.

       

      Best Regards,

      Dale