Filter to only show Relevant Dimension Values

Hi Laflet​ ,

We can do it using 'Custom' option in the dashboard filter.
By default, when you use a field from a Dimension table, Sisense shows all values from that table, even those not linked to any fact records.
Add below jaql in the 'Custom' option of the filter and apply. Then set it as background filter. Here, replace [fact_table.Id] with the table name and field name of your fact table column.

{
  "attributes": [
    {
      "dim": "[fact_table.Id]",
      "filter": {
        "exclude": {
          "members": [
            "N\\A"
          ]
        }
      }
    }
  ]
}

Please let me know if you have any questions

-Hari