Curious question about data visibility in chart

[AnneEb]

Hello 🙂
I have a curious question. 
In an already published app I have a sheet where I want to control gross profit made. Specifically the sheet is supposed to show only products where the gross profit % is lower than a minimum gross profit % that was set for the product. 

For instance I have a table that looks somewhat like this:

Now I have set filters for another product that hits above the minimum gross profit percentage and this is where things get weird. The new product has sold 3 times with a gross profit percent of roughly 24% with a minimum of 6% so obviously it does not show in the table. The table hence looks like this: 

However, the filter options are not greyed out. I can still filter for the product's supplier for example as can be seen here (the top entry is still white, all has been pixelated for data protection reasons). When I select the supplier, nothing changes in the table though.

Also on the same sheet I can see that the number of sales is three

So the data seems to be kinda there because the KPI shows the "3" and I can also select filters but not show up in the table. How can that be? I checked every single thing on the sheet. There is not condition set and no variable anywhere that would explain this. I need to fix a bug on this sheet and I am really curious to know how this came to be. The developer who created this sheet does not work at my company anymore so I cannot ask him. If anyone has any idea I would be more than happy to hear about it. 
Thank you all in advance 🙂 

[Or]

Since you haven't included any of your actual expressions, it's a bit hard to guess... that said, keep in mind that the information displayed in a specific table field does not filter the application. 

[AnneEb]

So that is because there aren't any actual expressions in the sheet. There are only count([fieldname]) for the amount of sales and then there is one sum([gross profit]) / sum([revenue]). Apart from that all other things used on the sheet are field names.

[Or]

In that case, it sounds like standard behavior - your table has a setting to only display certain values, but this filters the table rows, not the application. All other objects will not reflect the table's filter, and selections (regardless of where they're made from) will also not be impacted.