How to ignore page level filters

[Peppearson]

Hi,

I have a page level filter that excludes any rows which are "remove" under the status column.

ID	Status	Revenue
123	Keep	1791
124	Remove	4104
125	Remove	9166
126	Remove	3013
127	Keep	1651
128	Keep	2906
129	Keep	4475
130	Keep	1378

I've then created a revenue measure which ignores the status filter.

However when i pull the ID and Revenue measure into a table visual this is what i see:

ID	Revenue Measure
123	1791
127	1651
128	2906
129	4475
130	1378
Total	28,484

The total is correct but the only id's that are showing within the table are the "keep" rows.

Is there a way I can get the ID field to ignore the page level filter as well?

Thanks

[lbendlin]

Show your work. Are you using REMOVEFILTERS() in your measures?