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.
When I try to do this I get error value – I assume because the same measure has different values across the pages so the summary page cannot reconcile which is needed…