FILTER – filters in DAX (DAX – Power Pivot, Power BI)

Functions, that restricts table to some rows only. These selected rows can be provided to other functions to calculate a measure.
In this sample table, we can calculate Revenue for Strawberry ice cream only:
  • Strawberry ice cream revenue = CALCULATE(
       SUM(‘Table'[Revenue]);
       FILTER(‘Table’;’Table'[Item]=”Strawberry ice cream”))

Because:

  • CALCULATE puts SUM and FILTER together
  • SUM declares summarizing
  • FILTER restrict summarizing to “Strawberry ice creams” only.