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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
Marc_Ponick
Regular Visitor

Sum Totals from visuals on separate pages with their own separate filters

Hi,

Working on a forecast model that has one page for each Director, and a total page for the VP that is the sum of the 4 director pages.

There is only 1 data set.

All Directors have identical filters available to them (15 in total), but can choose whatever they like to create their own custom view.

Slicers are not sync'd accross the report as the directors can choose to include or exclude whatever is relevant to themselves.

The Pages all have 1 Table visual with an identical product column and a $ column.

Eg: (Director 1)

Product  |  Value

Cars        | $50

Dogs      | $25

Cats        | $25

Total:       | $100

 

The directors choose their respective filters and their tables total:

Director 1 total = $100

Director 2 total = $150

Director 3 Total = $120

Director 4 Total = $180

 

The VP page will have an identical table visual but the $ column needs to be the sum of the 4 Directors individual totals. The VP page will not have filters, it's simply a summary of the other 4 table visuals on the other pages and should equal $550 using the above example.

How can I create a Sum of the four separate visuals? 

This is built in desktop and published to a premium workspace.

 

Thanks,

Marc

2 REPLIES 2

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors