Forum Discussion

adriansuteu's avatar
adriansuteu
Advocate 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!

Vvelarde's avatar
Vvelarde
Community Champion
9 years ago

adriansuteu

 

Hi, Are you applied some kind of filter or slicer in your page?

 

 

 

 

Jollyjolie's avatar
Jollyjolie
New Member
2 years ago

hello,

 

I am experiencing the same issue. CountA, CountAX, Countrows retutning the wrong count of numbers in my pbix file. Do I have to separate the source files as the result is an error