Filter Context: One Measure for Every Slicer Combination
This lesson is part of the course
In this lesson
You turn three slicer cells (region, group, month) into a filter context and build sales, orders and average-order-value measures that answer every combination – including «(All)».
Buy the course once for $9.99 to unlock every lesson and lab, the final exam and the certificate – lifetime access, no subscription.
Lessons in this course
- Columns vs Measures: Line Margin vs Total Margin % Locked
- Filter Context: One Measure for Every Slicer Combination Locked
- Removing & Keeping Filters: Share of Total, of Region & of Parent Group Locked
- Semi-Additive Measures: Closing & Average Stock Balances Locked
- Ranking with Ties, a Top 5 & the «Others» Line Locked
- New vs Returning Customers per Month Locked
- Dynamic Customer Segments from a Band Table Locked
- Capstone: Measure Branching & a KPI Page that Reconciles Locked