Filter and Sort Data (SSAS Tabular)

When you are working with tables in tabular model, you can filter or sort data by using controls in the model designer. You can also create filters within calculations, to control the data that is used from a column or table of data. Each type of filter works only in its respective window.

Related Tasks

Topic	Description
Sort Data in a Table	Tasks in this topic describe how to sort data in a table by letters or by numbers.
Filter Data in a Table	Tasks in this topic describe how to apply custom filters to control the way that rows are displayed.

For information about filtering data in DAX formulas, see Filter Data in Formulas (SSAS - Tabular Models).