Help: Odd Filter Behavior - Data appearing in table is missing in basic filtering (filter pane)

[cryptopeck]

Okay Team - After years of getting immense value out of this forum, this is my first post.

Context: I work in hospitality, we aggregate lots of data from 3rd parties. The report in question is a culmination of Profit & Loss data, Labor data, and various budgets.

The problem: On a tab that appears unfiltered (none active in filter pane, no synced filters), I have a matrix (Matrix 1A) which has two row fields from Table "Financials Legend SS" Department (ex. S&M) and SubType (ex. Management Payroll). The matrix shows the detail that I want, yet my visual level report filter pane shows only limited options (Filter Pane 1A).

The caveat: This behavior only happens when I apply ANY filter to the table. The filters I have to use are slicers for: Year, Qtr, Month, and Hotel Name. The first 3 come from the Date table and the fourth comes from the Property table(both 1 to many to Financials).

This odd behavior also appears on another column from the Legend table, Type which can also be seen in the filter pane screenshot. Basic filtering for that column should show more values (ex. "Revenue" and "Rooms Qty"). Note that I do not need these values for Matrix 1A, but in theory they should be there in the filter pane.

I have spent an outrageous amount of time on this forum, others, and in my own head troubleshooting this issue. I'd appreciate any assistance.

Matrix 1A

Filter Pane 1A

Table: Financial Legend SS

Table: Financials

[cryptopeck · Accepted solution]

Well I went to bed and woke up this morning with an idea... an idea which solved the issue.

The problem was caused by a bi-directional filter in a relationship between contextually unrelated tables. Ultimately this was driven by a larger modeling error involving an associative entity that was doing its job in one place, but causing problems in another.