Ben Richardson digs into a function:
If you’ve ever tried to build a measure that needed more filtering power than a basic slicer, you’ve probably hit a wall.
That’s where DAX’s FILTER function comes in.
While visual filters and slicers work great for basic scenarios:
FILTER gives you row-level control to create sophisticated calculations that respond dynamically to your business logic.
Click through for an explanation of the function, as well as several examples of how it works.