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
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.
Solved! Go to 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.
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.
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 |
|---|---|
| 101 | |
| 76 | |
| 56 | |
| 51 | |
| 46 |