Subtracting Sums Across Report Pages

[Amerikaner]

I have 6 disconnected slicers. I have Report 1 and Report 2. The slicers are not sync'd between Report 1 and Report 2.

Report 1 sets the 6 disconnected slicers and calculates a SUM (Measure)

Report 2 sets the 6 disconnected slicers to different values and calculates a different SUM (Measure)

Is it possible to create a measure using KEEPFILTERS at the report level to subtract Report 1 SUM from Report 2 SUM?

[v-deddai1-msft]

Hi @Amerikaner ,

You should combine these two sum into one report. If you use dirll-through function you can use Keep all filters to pass filter from report1. But it will work on the whole report page.Please refer to https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-drillthrough#pass-all-filters-in-dr...

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Best Regards,

Dedmon Dai

[Amerikaner]

Is it possible to access this value (retaining the target page's report filters) using cross-report drill through?

[Gabriel_Walkman]

Hi!

I'd guess this could only be done if everything is on one page. MAYBE through some unwieldy gimmickry by making a synced and hidden copy of the other report so that they are kind of on the same page.

Or make synced copies of both reports to a summary report page?