Forum Discussion
Phantom Filter on Grid
- Anonymous2 years ago
I don't think the issue is hidden filters, i think the issue is the columns in your top grid. There is something about the columns in your top grid that is causes certain records to have "blank" results and are thus hidden. From your screenshot, you can see that the top grid only has 2 filters applied, both are your slicers.
To test my theory, remove every column from the top grid besides Status and Cnt. If you suddenly get the correct numbers, you know its one of the columns that were removed. You can then individually add them back in until the numbers disappear again.
I don't think the issue is hidden filters, i think the issue is the columns in your top grid. There is something about the columns in your top grid that is causes certain records to have "blank" results and are thus hidden. From your screenshot, you can see that the top grid only has 2 filters applied, both are your slicers.
To test my theory, remove every column from the top grid besides Status and Cnt. If you suddenly get the correct numbers, you know its one of the columns that were removed. You can then individually add them back in until the numbers disappear again.
YOU WERE TO RIGHT!
I had a column that was a Sum of a value that was only on some records. This seems to have caused only records with a value in this field to be shown.
Thank you for your patience.