Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Learn from the best! Meet the four finalists headed to the FINALS of the Power BI Dataviz World Championships! Register now
Looking to have a measure return a sum that retains the context of a slicer but ignores the context of the row on a table visual.
Here is a simple example table of data:
Here is a simple table visual that intrinsically summarizes the values. With no Category filter applied the sum is 51.
Filter the table to Animals and Colors, and the new total is 29.
I need a measure that will return these totals from the slicer but ignore the row-level context of the table visual.
I tried variations on the following code:
DynamicSubtotal =
CALCULATE(
SUM('Fact Table'[Values]),
ALLSELECTED('Fact Table'[Category]),
VALUES('Fact Table'[Category])
)
But I can only return the sum of all Categories ignoring the slicer, or all categories including the context of the slicer and the row. How do I keep the slicer context but not the row context?
Expected result:
Thanks in advance
Solved! Go to Solution.
Nevermind,
Solved it myself with the following code:
Nevermind,
Solved it myself with the following code:
Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.
Check out the February 2026 Power BI update to learn about new features.
| User | Count |
|---|---|
| 52 | |
| 51 | |
| 35 | |
| 15 | |
| 14 |
| User | Count |
|---|---|
| 92 | |
| 75 | |
| 41 | |
| 26 | |
| 25 |