Forum Discussion

adriansuteu's avatar
adriansuteu
Icon for Advocate I rankAdvocate I
9 years ago
Solved

Count and Countrows returning the wrong figure

Hi.   I have a table that contains ~2900 rows with columns. You can see it in the screenshot below.   I am trying to count the orders (each order has a row in this table) and create visualization...
Need Help
  • adriansuteu's avatar
    adriansuteu
    9 years ago

    Hi.

     

    I solved the problem.

    I guess it was some kind of bug.

     

    All I did was to copy the source data (the whole table as it is), from a multiple sheet xlsx to a csv file and then use that file as source. And now everything works fine, COUNT, COUNTA and COUNTROWS.

     

    Thanks for your interest!

Anonymous's avatar
Anonymous
Not applicable
7 years ago

I faced the same issue.

 

I have country names in a column and I need to count the number of times they appear.

 

I used the following DAX to count the number of times they appear in the table -:

 

Matches Won = COUNT('Cricket Data'[Winner])
 
But, it gave me a terrible result when I put it against the country names. It actually gave me the number of times they appear in "Country" column rather than giving it from the "Winner" column.
 
I think its a bug.
 
Please fix this ASAP.