DAX has a class of functions that perform data filtering. For given arguments, as a result, they return filtered table. Filter functions are usually used in combination with another DAX function, and their specificity is to allow creating measures that ignore the limitations of existing filters in a Pivot Table, as well as interactive filters such as Slicers and Timeline. In this recipe you will be briefly acquainted with these functions.
In one of previous recipes we were talking about basic concepts of DAX, where you’ve got acquainted with calculated columns. Now let’s say something about how to manipulate them within the table that exist in the Data model. First, we will show how to filter them, then how to remove filters and how to perform sorting. Then we will be talking about adding a new column, “freezing” and “unfreezing” columns, changing the column width, renaming…
Pivot tables (Pivot table reports) are a tool for creating interactive reports based on the range of selected data or structured tables. Columns from source tables are used as reporting dimensions by aggregation of data (measures) or using them to analyze in rows, columns, as filters (dimensions) … Once made, the Pivot tables are easily changed by adding or removing dimensions, giving us more different look at the unique original dataset.