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
