Count Rows filters versus total rows

DAX DAX Calculations
1

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.

Ideas?
Ethan

2

@stiefel.ed,

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

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

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

  • Brian
3

Thank you!!