Filter to only show Relevant Dimension Values | Help and How-To

Luke Flett · 2025-10-28T22:55:10.037000Z

Morning Sisense community! I have my Fact Table and a related Dimension Table. My dimension table contains more unique values than are actually present in the fact table. When I use a field from the Dimension Table as a filter, the filter displays all values from the dimension, even those that have no corresponding fact records. I only want the filter to show dimension values that are relevant to the data in the fact table. Example Tables: fact_table dimension_table iddim_iddim_iddim_name111one222two313three424four fact_table and dimension_table have a relationship in the EC based on dim_id Desired Outcome: In the filter based on dim_name, I only want to see "one" and "two", but currently, I see all four: "one," "two," "three," and "four."How do I achieve my desired outcome?

MoreDiscussions

Filter to only show Relevant Dimension Values | Help and How-To | Sisense Community