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

Hi powerrdl

First lets start with your "Edit Queries" section of Power BI.  There is a button for that on the Ribbon under Home.

 

Your table should look something like this if it is correct:

 

See how row 2 for Locn is coming up as null?  That what i'm hoping to see in your data, but i'm expecting in your data source that it might not be showing that.  Right clicking on Locn here is where the Trim option is from my earlier post.

powerrdl's avatar
powerrdl
Helper I
9 years ago

Hi Anonymous

 

You are right ! I right clicked in Edit Queries and Transformed as instructed, but it is still not giving 'null' for Product 2 :(

 

Regards

Rameen Dhall

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    Thats ok! This just means we are making progress.  Doing this normally works in Excel and i expected that to work here, but it looks like it hasn't.  I just tried on my sample set and got the same result.  No matter, lets add another step.  Still in that query editor, highlight the column and right click and select "Replace Values"

     

    In the pop up, leave the 'Value to Find' empty and write the word null into 'Replace With'.  It should detect that null is a keyword and then your data should look like my screenshot.