# Filter a dataset based on another dataset **URL:** \ **Category:** Q&A\ **Tags:** dashboard-embed, developer, quick-sight\ **Created:** [October 7, 2025, 9:47am UTC](https://community.amazonquick.com/t/filter-a-dataset-based-on-another-dataset/49969 "2025-10-07T09:47:21Z")\ **Posts on this page:** 5\ **Page:** 1
**Author:** ![michael.casalinuovo](https://avatars.discourse-cdn.com/v4/letter/m/3da27b/32.png) [@michael.casalinuovo](https://community.amazonquick.com/u/michael.casalinuovo)\ **Post date:** [October 7, 2025, 9:47am UTC](https://community.amazonquick.com/t/filter-a-dataset-based-on-another-dataset/49969/1 "2025-10-07T09:47:22Z")
Hello, I have an analyse based on a dataset with a Department column. I have another dataset in which I have a list of brokers with the departments in which they operate.(A broker can operate in several departments, so I have several lines for that broker). In my analyse, I would like to set up a filter on the broker so that it filters my first dataset to keep only the rows with the departments of the selected broker(s). Is this possible? ---
**Author:** ![Xclipse](https://d2orw1595917va.cloudfront.net/user_avatar/community.amazonquick.com/xclipse/32/20455_2.png) [@Xclipse](https://community.amazonquick.com/u/Xclipse)\ **Post date:** [October 7, 2025, 10:46am UTC](https://community.amazonquick.com/t/filter-a-dataset-based-on-another-dataset/49969/2 "2025-10-07T10:46:58Z")
Hi @michael.casalinuovo Please refer to the following Quick Sight documentation and community post this might be helpful for you. > **[Using QuickSight parameters and controls to drive interactivity in your...](https://aws.amazon.com/blogs/big-data/using-quicksight-parameters-and-controls-to-drive-interactivity-in-your-dashboards/)** > > Amazon QuickSight added support for parameters, on-screen controls, and URL actions earlier this year. In this blog post, we walk through several examples to show how you can use these capabilities within interactive dashboards for your audience. > [@How to filter multiple datasets using a single filter originating from a separate dataset in Analysis?](https://community.amazonquick.com/t/how-to-filter-multiple-datasets-using-a-single-filter-originating-from-a-separate-dataset-in-analysis/11840): > > I have four different datasets in Analysis, each containing an “account” column that needs to be filtered by a single filter originating from a fifth dataset. This fifth dataset contains all possible accounts, along with additional information such as country, segment, size, etc. Using this separate dataset as the source for the filter is essential to ensure that all accounts are included and that I can use the additional account information in other filters. If I create the filter from one of t… ---
**Author:** ![WLS-Luis](https://d2orw1595917va.cloudfront.net/user_avatar/community.amazonquick.com/wls-luis/32/36723_2.png) [@WLS-Luis](https://community.amazonquick.com/u/WLS-Luis)\ **Post date:** [October 22, 2025, 7:42pm UTC](https://community.amazonquick.com/t/filter-a-dataset-based-on-another-dataset/49969/3 "2025-10-22T19:42:50Z")
Hi @michael.casalinuovo, Hope this message finds you well! Just checking in since this thread hasn’t received a response in a while. Were you able to see Xclipse’s most recent message and/or find a solution to the question yourself? If we do not hear back within the next 3 business days, I’ll go ahead and close out of this topic. Thanks! ---
**Author:** ![WLS-Luis](https://d2orw1595917va.cloudfront.net/user_avatar/community.amazonquick.com/wls-luis/32/36723_2.png) [@WLS-Luis](https://community.amazonquick.com/u/WLS-Luis)\ **Post date:** [October 27, 2025, 2:44pm UTC](https://community.amazonquick.com/t/filter-a-dataset-based-on-another-dataset/49969/4 "2025-10-27T14:44:34Z")
Hi @michael.casalinuovo, Since we have not heard back, I’ll go ahead and close this topic. However, if you have any additional questions, please feel free to post again in the Quick Community and link this thread for any relevant info! Thank you! ---
**Author:** ![WLS-Luis](https://d2orw1595917va.cloudfront.net/user_avatar/community.amazonquick.com/wls-luis/32/36723_2.png) [@WLS-Luis](https://community.amazonquick.com/u/WLS-Luis)\ **Post date:** [October 27, 2025, 2:44pm UTC](https://community.amazonquick.com/t/filter-a-dataset-based-on-another-dataset/49969/5 "2025-10-27T14:44:36Z")