Field filter dropdown is not showing all of the expected options

[carolineloop]

Describe the bug

I have a field filter linked to all of the charts on my dashboard and there should be 3 options showing up in the dropdown, but only 2 are showing up. I triple checked that the data contains all 3 values, and for whatever reason the third will not show up. The only way I can get it to show up is if I make all 3 the default value (see screenshot). But as soon as I unselect the missing value "UPS," it disappears from the dropdown.



I'm confident that "UPS" data is in the charts on the dashboard, because when I set it to ONLY use UPS using the hack I figured out, the dashboard is populated with data (see screenshot).

To Reproduce

1. Go to this dashboard
2. Click on the Carrier filter
3. See error - the options should be "UPS" "FedEx" and "DHL," but only "FedEx" and "DHL" are showing up. If you remove the filter all together, you will see that UPS data does indeed exist in the reports that this filter is attached to.

Expected behavior

This dropdown filter should be showing 3 options, not 2: "UPS" "FedEx" and "DHL"

Logs

No response

Information about your Metabase installation

{
  "browser-info": {
    "language": "en-US",
    "platform": "MacIntel",
    "userAgent": "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/124.0.0.0 Safari/537.36",
    "vendor": "Google Inc."
  },
  "system-info": {
    "file.encoding": "UTF-8",
    "java.runtime.name": "OpenJDK Runtime Environment",
    "java.runtime.version": "11.0.23+9",
    "java.vendor": "Eclipse Adoptium",
    "java.vendor.url": "https://adoptium.net/",
    "java.version": "11.0.23",
    "java.vm.name": "OpenJDK 64-Bit Server VM",
    "java.vm.version": "11.0.23+9",
    "os.name": "Linux",
    "os.version": "5.10.215-203.850.amzn2.x86_64",
    "user.language": "en",
    "user.timezone": "GMT"
  },
  "metabase-info": {
    "databases": [
      "postgres",
      "snowflake",
      "h2"
    ],
    "hosting-env": "unknown",
    "application-database": "postgres",
    "application-database-details": {
      "database": {
        "name": "PostgreSQL",
        "version": "14.10"
      },
      "jdbc-driver": {
        "name": "PostgreSQL JDBC Driver",
        "version": "42.7.2"
      }
    },
    "run-mode": "prod",
    "version": {
      "date": "2024-05-13",
      "tag": "v1.49.10",
      "hash": "9e8fc83"
    },
    "settings": {
      "report-timezone": null
    }
  }
}

Severity

Annoying

Additional context

metabase-bug.webm

[paoliniluis]

Are the filters linked_

[carolineloop]

Yes the filter is linked to all of the other field filters on the dashboard. However, the one that removes "UPS" is the tenant_qid filter. Except when I run a "distinct" query with the table that the field filter is derived from WITH the tenant_qid field filter applied, it returns all 3 expected values. So I think it must be bug that's causing only 2 to show up in the dropdown.