Filter an Itemset in an Association Rules Model
Applies to: 
SQL Server 2019 and earlier Analysis Services 
Azure Analysis Services
Fabric/Power BI Premium
Important
Data mining was deprecated in SQL Server 2017 Analysis Services and now discontinued in SQL Server 2022 Analysis Services. Documentation is not updated for deprecated and discontinued features. To learn more, see Analysis Services backward compatibility.
In Microsoft SQL Server SQL Server Analysis Services, you can filter the itemsets that are displayed in the Itemsets tab of the Microsoft Association Rules Viewer.
To filter an itemset
On the Mining Model Viewer tab of Data Mining Designer in SQL Server Data Tools, click the Itemsets tab of the Association Rules Viewer.
Enter a rule condition in the Filter itemset box. For example, a rule condition might be "Touring-1000 = existing"
Click Enter.
The itemsets are now filtered to display only those itemsets that contain the selected items. The box is not case-sensitive. Filters are stored in memory so that you can select an old filter from the list.
See Also
Feedback
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see: https://aka.ms/ContentUserFeedback.
Submit and view feedback for