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(
       FILTER(‘Table’;’Table'[Item]=”Strawberry ice cream”))


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

Leave a Reply

Your email address will not be published.


clear formPost comment