Removing & Keeping Filters: Share of Total, of Region & of Parent Group
This lesson is part of the course
In this lesson
You calculate three different percentages for the same product row – share of the grand total, share within its region and share of its parent group – and a slicer-driven group share within the selected region.
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