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

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Yeah thats a real mystery to me too.  I've never played with it enough to notice.  You are right about what MSDN says and I don't see it behaving this way.

 

Still, at least you learned something about the nulls!

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