We've already looked at some of the filter functions in previous chapters when we were looking at the evaluation contexts. In Chapter 1, What is DAX? and Chapter 5, Getting it into Context, we looked in some detail at the CALCULATE function. We also touched on the ALL, FILTER, and KEEPFILTERS functions. In this chapter, we'll revisit these and take a more detailed look at some of the other functions in this group.
Introduction to filter functions
Filter function reference
The following gives a list of the DAX functions found in the filter function group, along with a brief description of the functionality provided by each:
- ALL: This returns a table that includes all of the rows of a specified table or all of the...