Ravindra BagaleCourses & study guides

22. Filters and Slicers

22.3 Measure Filters (Visual Level)

At the visual level you can filter by a measure, for example show only stores where Total Orders is greater than 500. Drag the measure into Filters on this visual › choose Show items when the value is greater than 500 › Apply filter. Measure filters are evaluated per item of the visual, after other filters.

Ravindra Bagale's Tip

Friends, many students try to use a measure in the page-level filter well and can't. Measure filters work only at the visual level. If many visuals need the same condition, consider a calculated column or put the condition inside the measures. Don't worry – after doing it two or three times, it becomes a habit.