COUNTROWS with filtered data

[jacobtmelton]

First of all, I'm about as new to this software as can be, so please bear with me. I've got a table "Inventory" with a column "Scope," and have it filtered to not display items with certain values for "Scope." Now, I want to get a count of the rows that fit into this filter, but the COUNTROWS ignores the filter and still gives me a total of all rows. 

All this being said, I appreciate any help in advance! 

[Whitewater100]

Hi:

If you are seeking a measure to count specific values under the scope field.

Specific Scope = CALCULATE(COUNTROWS(Table[Scope]), Table[Scope] = "Value"))

and repeat for each separate value under scope. e.g. "instock", "intransit"  etc.

[Whitewater100]

Hi:

You can either bring that Field Scope into a table of amtix visual and drop COUNTROWS in values field well.

Or add a slicer from scope and select the scope you want and CR should adjust.

Hope this helps.

[Whitewater100 · Accepted solution]

Sorry:

Hi:

You can either bring the field Scope into a table oor amtrix visual and drop your  COUNTROWS measure in values field well.

Or add a slicer for column scope and select the scope value you want and CountRows should adjust.

Here is example where slicer is Grade and data below in a table.