Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now

Reply
jdoc_18
New Member

Store and use the value of a page-sliced measure across multiple pages

 

Hi all - grateful for any guidance on the multi-use of single tables and measures in PowerbI - I've spent weeks trying to figure this out.

 

I have a page with 4 slicers. Each slicer is based on a different small table (yes/no, 1-10, etc)

I then have some measures - "vol", "start date", "End date". 

These measures are calculated on the fly by Power BI depending on what is selected in the slicers (plus some static data). So far so good.

 

My static data covers 12 countries.

I need a page for each country.

 

I then need a summary tab at the end which totals the vol from each of the pages and displays the start/end date for each country.

 

Essentially I need to 'capture' the 'page-specific' values of the measures and store them somewhere and do the same for pages 2,3,4 etc to then pull them into summary.

 

is this possible?

 

Any guidance VERY gratefully received.

1 ACCEPTED SOLUTION

Only report level filters will work in your scenario.  Use multiple copies of the  dimension table if the same field is filtered differently across pages.

View solution in original post

3 REPLIES 3
lbendlin
Super User
Super User

Move your slicers to the filter pane, where they belong. Put them into the "filters on all pages"  section.

Thanks but the filters are not the same across all pages. I have filtered values showing per page which I need to summarise

Only report level filters will work in your scenario.  Use multiple copies of the  dimension table if the same field is filtered differently across pages.

Helpful resources

Announcements
November Power BI Update Carousel

Power BI Monthly Update - November 2025

Check out the November 2025 Power BI update to learn about new features.

Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors