Count Rows filters versus total rows

Hopefully this is simple:

I am trying to show “Cases Observed: x/Total”

x = number of data points filtered (I am using CountRows- works great)

Total = Total number of rows in my database

I cannot get the total number of rows of the database to stay static. Any filter changes it along with the filters amount observed.



You’ll need to remove all the filters on your COUNTROWS measure to get it to stay static, ala

Total Rows =
    COUNTROWS( Table ),
     REMOVEFILTERS( Table )                           

You can also use ALL(Table) in place of REMOVEFILTERS(Table)

  • Brian

Thank you!!