Forum Discussion

powerrdl's avatar
powerrdl
Helper I
9 years ago
Solved

Bug in COUNT function?

  I am getting same output with COUNT and COUNTA functions for all columns of above data. COUNT(Locn) gives output as 5 even though there are 4 entries and no numeric entry. Not getting error ...
Need Help
Show and Tell
  • v-haibl-msft's avatar
    v-haibl-msft
    9 years ago

    Anonymous

     

    COUNTA can count TRUE/FALSE column but COUNT still raises an error.

     

    Best Regards,
    Herbert

powerrdl's avatar
powerrdl
Helper I
9 years ago

So back to my original question -- Is it a BUG ?!! Or has the functionality been changed ?

 

Regards

Rameen

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

powerrdl

 

Hi,

 

“Count” acts strange in Power BI, which is different from the documents. I have reported it internally to Power BI Team and I will post here as soon as I get feedback.

 

 

 

Best Regards!

Dale