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!Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
I'm sure there is a simple answer that I can't find during my searching.
I have a table "Orders" which is being filtered by slicers. I want to add a column called "Total" which repeats the total order value.
Eg orders table:
Product, Qty, Value, Total
Pen, 5, $10, $14
Pencil, 10, $1, $14
Eraser, 3, $3, $14
Notice how total is the total value of all orders, but repeated. I want the Total measure to be affected by slicers applied to Orders, but unaffected by the row filter in the table. I also want the Total measure to be unaffected if I click a row of the table.
So far I have this:
Hi!
Let me know if I misunderstood, but could ALLSELECTED() be something that helps?
Total Value =
CALCULATE(
sum('Orders'[Value]),
ALLSELECTED('Orders'))Without slicer
With slicer
Thanks, but if I click on a row then ALLSELECTED doesn't work.
Check out the November 2025 Power BI update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
| User | Count |
|---|---|
| 103 | |
| 80 | |
| 64 | |
| 50 | |
| 45 |