Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

countrows() counts wildly wrong

I've got a simple measure:

 

NumberOfRows = COUNTROWS(Ordre)

 

.. That is returning the value '60' and I have no filters on the visual, the pages or report.

 

But the table (Ordre) has a lot more rows than that around 40k to be exact. And I am starting to rip out my last hair... What could be wrong - is it a bug? What haven't I looked at?

 

Jon

 

 

Need Help
  • parry2k's avatar
    parry2k
    6 years ago

    hmmm, not sure how to proceed?

     

    How does relationship diagram looks like in case there are more tables? If yes, are you filterig on other table which may be filtering order table.

6 Replies

  • parry2k's avatar
    parry2k
    Super User
    6 years ago

    Anonymous can you share pbix file? very hard to think what could be wrong?

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      I can do just about anything but that - sorry. I wish I could - or was able to reproduce under other circumstances. It looks like a bug - but it's probably me... 

       

      Jon

      • parry2k's avatar
        parry2k
        Super User
        6 years ago

        well dont think it is a bug but never know. May be create a sample pbix with sample data and see if we can work thru that one