DAX function FILTER functions (filtering functions) are used to get values from the table. Some functions enable additional filtering in a given table. These functions are often part of different functions as is nested parameter and enable dynamic calculations. They often serve as a value filter for function  CALCULATE. Mostly it is the case of typical member of this category – FILTER function. For instance when we want to create metrics summing up values of some column but we need to limit the column based on some requirement = filter.

Script example representatives of DAX category function FILTER (function is named identically to the whole category). In the example of metrics is total sum of the sales > 1000

Sales USD > 1000 =
SUMX (
    FILTER (
        Sales,
        Sales[UnitCosts] * Sales[Quantity]
            > 1000
    ),
    Sales[UnitPrice] * Sales[Quantity]
)

List of FILTER Functions in DAX Language for Power BI

1. ADDCOLUMNS
2. ADDMISSINGITEMS
3. ALL
4. ALLEXCEPT
5. ALLNOBLANKROW
6. ALLSELECTED
7. CALCULATE
8. CALCULATETABLE
9. CALENDAR
10. CALENDARAUTO
11. CROSSFILTER
12. CROSSJOIN
13. CURRENTGROUP
14. DISTINCT
15. EARLIER
16. EARLIEST
17. EXCEPT
18. FILTER
19. FILTERS
20. GENERATE
21. GENERATEALL
22. GROUPBY
23. IGNORE
24. INTERSECT
25. ISONORAFTER
26. KEEPFILTERS
27. LOOKUPVALUE
28. NATURALINNERJOIN
29. NATURALLEFTOUTERJOIN
30. RELATED
31. RELATEDTABLE
32. ROLLUP
33. ROLLUPADDISSUBTOTAL
34. ROLLUPGROUP
35. ROLLUPISSUBTOTAL
36. ROW
37. SAMPLE
38. SELECTCOLUMNS
39. SUBSTITUTEWITHINDEX
40. SUMMARIZE
41. SUMMARIZECOLUMNS
42. TOPN
43. UNION
44. USERELATIONSHIP
45. VALUES