The camera sums Sales for all people caught in the spotlight created by Report, Page, Visual, and Slicer filters.
0
$0
$0
Instant photo
Who is lit up right now
Imagine Total Sales = SUM(SalesTable[Sales]) as a camera. The filter context is the spotlight deciding which people step into frame.
The measure (camera) is fixed. Whoever stands in the lit area is summed; everyone else fades into the dark. Combine filters to narrow the spotlight.
Total Sales = SUM(SalesTable[Sales])
The formula never changes—only the rows that are lit by the filter context do.
The camera sums Sales for all people caught in the spotlight created by Report, Page, Visual, and Slicer filters.