Forum Discussion

Amerikaner's avatar
Amerikaner
Icon for Helper I rankHelper I
5 years ago

Subtracting Sums Across Report Pages

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?

Need Help

3 Replies

  • Gabriel_Walkman's avatar
    Gabriel_Walkman
    Icon for Continued Contributor rankContinued Contributor
    5 years ago

    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?

  • Amerikaner's avatar
    Amerikaner
    Icon for Helper I rankHelper I
    5 years ago

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

     

     

  • v-deddai1-msft's avatar
    v-deddai1-msft
    Icon for Community Support rankCommunity Support
    5 years ago

    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-drillthrough

     

    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