Forum Discussion

SarahHope's avatar
SarahHope
Icon for Helper II rankHelper II
3 years ago
Solved

COUNTROWS always returns the value 1

I am trying to count the rows in my table1 for which columnY contains the words "Ready for CAB"

The formula returns the number '1'.

RFC Count = CALCULATE(COUNTROWS('Table1'),FILTER('Table1','Table1'[ColumnY]="Ready for CAB"))

so I simplified and tried this below and it still returns "1".

totalrows = COUNTROWS('Table_owssvr')
 
I happen to know that it should be returning "8" today as I have that number from another report.
 
What am I doing wrong?
Thanks so much.
Need Help
  • PhilipTreacy's avatar
    PhilipTreacy
    3 years ago

    Hi SarahHope 

     

    Have you got any filters on the Page or on All pages?

     

    The RFC Count as you've written it should return 8 if ther's no filters and [ColumnY] def contains that text.

     

    Can you post your table?

     

    Phil

2 Replies

  • PhilipTreacy's avatar
    PhilipTreacy
    Icon for Super User rankSuper User
    3 years ago

    Hi SarahHope 

     

    Have you got any filters on the Page or on All pages?

     

    The RFC Count as you've written it should return 8 if ther's no filters and [ColumnY] def contains that text.

     

    Can you post your table?

     

    Phil

  • SarahHope's avatar
    SarahHope
    Icon for Helper II rankHelper II
    3 years ago

    I got this to work in my original report.  I have another report that is using the first report as a source.  I could not get this to work on that second report - only in the original.  It's a work around, but it will do for now.  Thank you.