Filter Data in Formulas - MSDN - Microsoft

Looking for help with Power Pivot in Excel 2013? ... You can create filters within formulas, to restrict the values from the source data that are used in calculations.

msdn.microsoft.com