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.
Comments closed